CREATE TABLE

Creates a new table object in the database.

Syntax:

CREATE [TEMP] TABLE [ IF NOT EXISTS ] table-specification
(
[ column-name data-type
       [ DEFAULT default-value ] [ NOT NULL ]
       [ PRIMARY KEY [ contraint-name ]
       | UNIQUE [ contraint-name ]
       | CHECK ( sql-condition ) [ contraint-name ]
       | REFERENCES table-name
             [ ( column-name [,...] ) ]
             [ ON DELETE CASCADE ]
             [ contraint-name ]
       ]
| PRIMARY KEY ( column-name [,...] ) [ contraint-name ]
| UNIQUE ( column-name [,...] ) [ contraint-name ]
| CHECK ( sql-condition ) [ contraint-name ]
| FOREIGN KEY ( column-name [,...] )
     REFERENCES table-name
             [ ( column-name [,...] ) ]
             [ ON DELETE CASCADE ]
             [ contraint-name ]
] [,...]
)
[ WITH NO LOG ]
[ IN tablespace-name ]
[ EXTENT SIZE integer ]
[ NEXT SIZE integer ]
[ LOCK MODE { PAGE | ROW } ]