Omnidex SQL: CREATE TABLE

<code SQL>

CREATE [[ <GLOBAL | 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”]

  [[,] [CONSTRAINT constraint]
  <UNIQUE [KEY] (column [, column …]) |
  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>