CREATE TABLE Syntax:

      – Selecting from an existing table

SELECT column1, column2, ...

INTO newtable

FROM existingtable

– Defining from scratch

CREATE TABLE tablename (

column1name datatype(size) [NOT NULL] [index1],

column2name datatype(size)[NOT NULL] [index2],

...

[,]CONSTRAINT multifieldindex [, ...]])

Single-field constraint:

CONSTRAINT constraintname {

PRIMARY KEY |

UNIQUE |

NOT NULL |

REFERENCES foreigntablename [(foreigncol1, foreigncol2), ...]

}

Multifield constraint:

CONSTRAINT constraintname (

PRIMARY KEY (primary1, primary2 , ...) |

UNIQUE (unique1, unique2 , ...) |

NOT NULL (notnull1, notnull2 , ...) |

FOREIGN KEY (ref1, ref2 , ...) REFERENCES foreigntable (foreigncol1, foreigncol2, ...)

}