|
1878.5.4
by Brian Aker
Update documentation. |
1 |
CREATE TABLE
|
|
1900.2.4
by Stewart Smith
fix more docs warnings: underline/overline too short |
2 |
============
|
|
1887.3.1
by Brian Aker
Update to documentation for create table and create schema. |
3 |
|
|
1945.3.3
by Marisa Plumb
updates to a few sql docs |
4 |
A CREATE statement in SQL creates an object inside of Drizzle. One of the most common CREATE command is the CREATE TABLE command. |
5 |
||
|
1887.3.1
by Brian Aker
Update to documentation for create table and create schema. |
6 |
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name |
7 |
(create_definition, ...) |
|
8 |
[engine_options] |
|
9 |
||
10 |
or: |
|
11 |
||
12 |
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name |
|
13 |
[(create_definition, ...)] |
|
14 |
[engine_options] |
|
15 |
select_statement |
|
16 |
||
17 |
or: |
|
18 |
||
19 |
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name |
|
20 |
LIKE different_table_name |
|
21 |
[engine_options] |
|
22 |
||
23 |
create_definition: |
|
24 |
column_name column_definition |
|
25 |
| [CONSTRAINT [symbol] ] PRIMARY KEY [index_type]
|
|
26 |
(index_column_name, ...) |
|
27 |
| INDEX [index_name] (index_column_name, ...)
|
|
28 |
(index_column_name, ...) |
|
29 |
| [CONSTRAINT [symbol] ] UNIQUE [INDEX]
|
|
30 |
(index_column_name, ...) |
|
31 |
| [CONSTRAINT [symbol] ] FOREIGN KEY [index_name] (index_column_name, ...)
|
|
32 |
reference_definition |
|
33 |
| CHECK (expr)
|
|
34 |
||
35 |
column_definition: |
|
36 |
data_type [NOT NULL | NULL] [DEFAULT default_value] |
|
37 |
[AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY] |
|
38 |
[COMMENT 'string'] |
|
39 |
[reference_definition] |
|
40 |
||
41 |
data_type: |
|
42 |
| INTEGER |
|
43 |
| BIGINT
|
|
44 |
| DOUBLE[(length, decimals)]
|
|
45 |
| DECIMAL[(length[,decimals])]
|
|
46 |
| DATE
|
|
47 |
| TIMESTAMP
|
|
48 |
| DATETIME
|
|
49 |
| VARCHAR(length) [COLLATE collation_name]
|
|
50 |
| VARBINARY(length)
|
|
51 |
| BLOB
|
|
52 |
| TEXT [BINARY] [COLLATE collation_name]
|
|
53 |
| ENUM(value1, value2, value3, ...) [COLLATE collation_name]
|
|
54 |
||
55 |
reference_option: |
|
56 |
RESTRICT | CASCADE | SET NULL | NO ACTION |
|
57 |
||
58 |
engine_options: |
|
59 |
engine_option [[,] engine_option] ... |
|
60 |
||
61 |
engine_option: |
|
62 |
ENGINE = engine_name |
|
63 |
{ engine_specific }
|