Omnidex SQL: CREATE TABLE

<code SQL> CREATE LOCAL>] TEMPORARY] TABLE table [NODE node] [OPTIONS “options”] [PHYSICAL “physical”] [AUTOFILTER “criteria”] [DATA_CACHING <DYNAMIC | NONE>] [PARTITION_BY “criteria”] [INDEX_MAINTENANCE index_maintenance] [( [[,] column datatype [DEFAULT <literal | niladic-function | NULL>] [USAGE usage] [FORMAT format] [[,] [CONSTRAINT constraint] <[NOT] NULL | UNIQUE [KEY] | DISTINCT [KEY] | PRIMARY [KEY] | [FOREIGN [KEY REFERENCES table(column[, column …]) [PREJOIN]>]

[<OMNIDEX | QUICKTEXT | FULLTEXT | CUSTOM | NATIVE> [INDEX]

[KEYWORDING]

[PROXIMITY]

[<CASE_INSENSITIVE | CASE_SENSITIVE>]

[STANDALONE]

[BITMAP]

[EXCLUDED_WORDS]

[PHONETIC]

[PREJOIN table]

[<RECORD_SPECIFIC | RECORD_COMPLEX>]]

[AS “select_item”]

DISTINCT [KEY] (column [, column …]) | PRIMARY [KEY] (column [, column …]) | FOREIGN [KEY] (column [, column …]) REFERENCES table(column [, column …] [PREJOIN]>] [[,] <OMNIDEX | QUICKTEXT | FULLTEXT | CUSTOM | NATIVE> [INDEX] index (<column | substring> [, <column | substring>…]) [KEYWORDING] [PROXIMITY] [<CASE_INSENSITIVE | CASE_SENSITIVE>] [STANDALONE] [BITMAP] [EXCLUDED_WORDS] [PHONETIC] [PREJOIN table] [<RECORD_SPECIFIC | RECORD_COMPLEX>

[[,] INDEX GROUP [(owner)]group (index, index [, index …])

)]

[AS “sql_statement”]

[<IN “filename” | ON [INSTANCE] instance>]

[WITH options]

<code>