Differences

This shows you the differences between two versions of the page.

--- dev:sql:statements:create_table:home [2009/12/04 15:52]
tdo
+++ dev:sql:statements:create_table:home [2012/10/26 14:28] (current)
@@ Line 1: / Line 1: @@
 {{page>:top_add&nofooter&noeditbtn}}
 <html><div align="center"><span style="color:red">DRAFT</span></div></html>
+====== Omnidex SQL: CREATE TABLE ======
+{{page>:sql_bar&nofooter&noeditbtn}}
-====== Omnidex SQL: CREATE TABLE ======
 ===== Description =====
 ===== Syntax =====
 <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]
+  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>

Back to top

dev/sql/statements/create_table/home.1259941934.txt.gz · Last modified: 2012/10/26 14:28 (external edit)

Sitemap Recent Changes