====== CREATE TABLE ======

===== Basic Syntax =====
<code sql>
CREATE TABLE tablename
(
  column  datatype  [NULL|NOT NULL]  [CONSTRAINTS],
  column  datatype  [NULL|NOT NULL]  [CONSTRAINTS],
  ...
);
</code>

===== Basic Example =====
<code sql>
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)
);
</code>

===== from SELECT statement =====
  * CREATE TABLE mytable SELECT * FROM myothertable WHERE somefield = NULL