CREATE TABLE Syntax:
–
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, ...)
}
–
Selecting from an existing table
SELECT column1, column2, ...
INTO newtable
FROM existingtable