CREATE clauses

CREATE clauses

CREATE
 statements partially support
TABLE
 and
INDEX
.

Examples

CREATE UNIQUE INDEX Table_Index ON Table1 (Column1)
CREATE INDEX IF NOT EXISTS Table_Index ON Table1 (Column1)
CREATE TABLE TempTable AS SELECT Column1 FROM MyTable WHERE Column1 > 5
CREATE TEMPORARY TABLE TempTable AS SELECT Column1 FROM MyTable WHERE Column1 > 5
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.