This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:create_table:home [2009/12/04 15:56] tdo |
dev:sql:statements:create_table:home [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | |||
| ====== Omnidex SQL: CREATE TABLE ====== | ====== Omnidex SQL: CREATE TABLE ====== | ||
| + | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| + | |||
| ===== Description ===== | ===== Description ===== | ||
| ===== Syntax ===== | ===== Syntax ===== | ||
| Line 21: | Line 22: | ||
| [FORMAT format] | [FORMAT format] | ||
| [[,] [CONSTRAINT constraint] | [[,] [CONSTRAINT constraint] | ||
| - | <[NOT] NULL | UNIQUE [KEY] | DISTINCT [KEY] | PRIMARY [KEY] | [FOREIGN [KEY]] REFERENCES table(column[, column …]) [PREJOIN]>] | + | <[NOT] NULL | UNIQUE [KEY] | DISTINCT [KEY] | PRIMARY [KEY] | [FOREIGN [KEY]] |
| + | REFERENCES table(column[, column …]) [PREJOIN]>] | ||
| [<OMNIDEX | QUICKTEXT | FULLTEXT | CUSTOM | NATIVE> [INDEX] | [<OMNIDEX | QUICKTEXT | FULLTEXT | CUSTOM | NATIVE> [INDEX] | ||
| [KEYWORDING] | [KEYWORDING] | ||
| Line 33: | Line 35: | ||
| [<RECORD_SPECIFIC | RECORD_COMPLEX>]] | [<RECORD_SPECIFIC | RECORD_COMPLEX>]] | ||
| [AS “select_item”] | [AS “select_item”] | ||
| - | |||
| [[,] [CONSTRAINT constraint] | [[,] [CONSTRAINT constraint] | ||
| <UNIQUE [KEY] (column [, column …]) | | <UNIQUE [KEY] (column [, column …]) | | ||
| Line 55: | Line 56: | ||
| [<IN “filename” | ON [INSTANCE] instance>] | [<IN “filename” | ON [INSTANCE] instance>] | ||
| [WITH options] | [WITH options] | ||
| - | |||
| <code> | <code> | ||