~drizzle-trunk/drizzle/development : contents of docs/create

~drizzle-trunk/drizzle/development : (revision 2191)

CREATE TABLE
============

A CREATE statement in SQL creates an object inside of Drizzle. One of the most common CREATE commands is the CREATE TABLE command.

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name
    (create_definition, ...)
    [engine_options]

    or:

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name
    [(create_definition, ...)]
    [engine_options]
    select_statement

    or:

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name
    LIKE different_table_name
    [engine_options]

create_definition: ::

    column_name column_definition
    [CONSTRAINT [symbol] ] PRIMARY KEY [index_type]
    (index_column_name, ...)
    INDEX [index_name] (index_column_name, ...)
    (index_column_name, ...)
    [CONSTRAINT [symbol] ] UNIQUE [INDEX]
    (index_column_name, ...)
    [CONSTRAINT [symbol] ] FOREIGN KEY [index_name] (index_column_name, ...)
    reference_definition
    CHECK (expr)

column_definition: ::

	data_type [NOT NULL | NULL] [DEFAULT default_value]
    [AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY]
    [COMMENT 'string']
    [reference_definition]

data_type: ::

	* INTEGER
	* BIGINT
	* DOUBLE[(length, decimals)]
	* DECIMAL[(length[,decimals])]
	* DATE
	* TIMESTAMP
	* DATETIME
	* VARCHAR(length) [COLLATE collation_name]
	* VARBINARY(length)
	* BLOB
	* TEXT [BINARY] [COLLATE collation_name]
	* ENUM(value1, value2, value3, ...) [COLLATE collation_name]

reference_option:
  RESTRICT | CASCADE | SET NULL | NO ACTION

engine_options:
    engine_option [[,] engine_option] ...

engine_option:
  ENGINE = engine_name
  { engine_specific }

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
1994.4.69 by Marisa Plumb edits and more conditional functions	4	A CREATE statement in SQL creates an object inside of Drizzle. One of the most common CREATE commands is the CREATE TABLE command.
1945.3.3 by Marisa Plumb updates to a few sql docs	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
1994.4.22 by Marisa Plumb create table fixes, index toc adjustments	23	create_definition: ::
1994.4.20 by Marisa Plumb fixed build warnings	24
1887.3.1 by Brian Aker Update to documentation for create table and create schema.	25	column_name column_definition
1994.4.22 by Marisa Plumb create table fixes, index toc adjustments	26	[CONSTRAINT [symbol] ] PRIMARY KEY [index_type]
	27	(index_column_name, ...)
	28	INDEX [index_name] (index_column_name, ...)
	29	(index_column_name, ...)
	30	[CONSTRAINT [symbol] ] UNIQUE [INDEX]
	31	(index_column_name, ...)
	32	[CONSTRAINT [symbol] ] FOREIGN KEY [index_name] (index_column_name, ...)
1887.3.1 by Brian Aker Update to documentation for create table and create schema.	33	reference_definition
1994.4.22 by Marisa Plumb create table fixes, index toc adjustments	34	CHECK (expr)
	35
	36	column_definition: ::
	37
	38	data_type [NOT NULL \| NULL] [DEFAULT default_value]
1887.3.1 by Brian Aker Update to documentation for create table and create schema.	39	[AUTO_INCREMENT] [UNIQUE [KEY] \| [PRIMARY] KEY]
	40	[COMMENT 'string']
	41	[reference_definition]
	42
1994.4.22 by Marisa Plumb create table fixes, index toc adjustments	43	data_type: ::
1994.4.20 by Marisa Plumb fixed build warnings	44
1994.4.22 by Marisa Plumb create table fixes, index toc adjustments	45	* INTEGER
	46	* BIGINT
	47	* DOUBLE[(length, decimals)]
	48	* DECIMAL[(length[,decimals])]
	49	* DATE
	50	* TIMESTAMP
	51	* DATETIME
	52	* VARCHAR(length) [COLLATE collation_name]
	53	* VARBINARY(length)
	54	* BLOB
	55	* TEXT [BINARY] [COLLATE collation_name]
	56	* ENUM(value1, value2, value3, ...) [COLLATE collation_name]
1887.3.1 by Brian Aker Update to documentation for create table and create schema.	57
	58	reference_option:
	59	RESTRICT \| CASCADE \| SET NULL \| NO ACTION
	60
	61	engine_options:
	62	engine_option [[,] engine_option] ...
	63
	64	engine_option:
	65	ENGINE = engine_name
	66	{ engine_specific }