==========================================================
Sams Teach Yourself SQL in 10 Minutes - ISBN 0672321289
Appendix A - Sample Table Scripts
Create Vendors table

DBMS specific notes
  All tables should have primary keys defined. This table should
   use vend_id as its primary key.
  If you are using Informix, explicitly state NULL for the vend_address,
   vend_city, vend_state, vend_zip, and vend_country columns.
  DB2 users will need to specify where the table is to be created.

Important: When using this SQL statement only include
text beneath the lines below.
==========================================================

CREATE TABLE Vendors
(
	vend_id		CHAR(10)	NOT NULL,
	vend_name	CHAR(50)	NOT NULL,
	vend_address	CHAR(50)	,
	vend_city	CHAR(50)	,
	vend_state	CHAR(5)		,
	vend_zip	CHAR(10)	,
	vend_country	CHAR(50)	
);

