SQL support / Static SQL statements |
Creates a new table object in the database.
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 } ]