Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

By Ronald R. Plew, Ryan K. Stephens

CREATE TABLE EMPLOYEE_TBL (EMP_ID VARCHAR(9) NOT NULL, LAST_NAME VARCHAR(15) NOT NULL, FIRST_NAME VARCHAR(15) NOT NULL, MIDDLE_NAME VARCHAR(15), ADDRESS VARCHAR(30) NOT NULL, CITY VARCHAR(15) NOT NULL, STATE CHAR(2) NOT NULL, ZIP INTEGER(5) NOT NULL, PHONE CHAR(10), PAGER CHAR(10), CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID));