Differences

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

--- dev:sql:statements:create_table:home [2009/11/26 20:26]
127.0.0.1 external edit
+++ 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 ======
-===== Description =====
+{{page>:sql_bar&nofooter&noeditbtn}}
+===== Description =====
 ===== Syntax =====
-  Statement
+<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>
 ===== Discussion =====

Back to top

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

Sitemap Recent Changes