Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Appendix D. CREATE TABLE Statements for Book Examples
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));