CUSTOMER_TBL

Team-Fly

---

 

	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 CUSTOMER_TBL  (CUST_ID             VARCHAR(10)    NOT NULL       primary key, CUST_NAME           VARCHAR(30)    NOT NULL, CUST_ADDRESS        VARCHAR(20)    NOT NULL, CUST_CITY           VARCHAR(15)    NOT NULL, CUST_STATE          CHAR(2)         NOT NULL, CUST_ZIP            INTEGER(5)       NOT NULL, CUST_PHONE          INTEGER(10), CUST_FAX            INTEGER(10),); 

---

Team-Fly

Top