{ CREATE table_kind | CT } table_specification,
QUEUE [ table_option [,...] ]
( QITS_specification )
[ index_specification [[,]...] ] [;]
- table_kind
[ SET | MULTISET ]
- table_specification
[ database_name. | user_name. ] table_name
- table_option
{ MAP = map_name |
[NO] FALLBACK [ PROTECTION ] |
NO JOURNAL |
FREESPACE = integer [ PERCENT ] |
data_block_size |
blockcompression |
CHECKSUM = { ON | OFF | DEFAULT }
}
- QITS_specification
QITS_column_name TIMESTAMP [ (6) ] NOT NULL DEFAULT
CURRENT_TIMESTAMP [ (6) ]
[ data_type_attribute [...] |
[ CONSTRAINT name ] CHECK ( boolean_condition )
]
QITS_attribute [,...]
- index_specification
{ [ UNIQUE ] INDEX [ index_name ] ( index_column_name [,...] ) |
[ UNIQUE ] PRIMARY INDEX [ index_name ] ( primary_index_column [,...] ) |
INDEX [ index_name ] ( index_column_name [,...] )
ORDER BY [ VALUES | HASH ] ( order_column_name )
}
- data_block_size
{ DATABLOCKSIZE = integer [ BYTE[S] | KBYTE[S] | KILOBYTE[S] ] |
[ MINIMUM | MAXIMUM ] DATABLOCKSIZE }
- blockcompression
BLOCKCOMPRESSION = { AUTOTEMP | MANUAL | ALWAYS | NEVER | DEFAULT }
[, BLOCKCOMPRESSIONALGORITHM = { ZLIB | ELZS_H | DEFAULT } ]
[, BLOCKCOMPRESSIONLEVEL = { value | DEFAULT } ]
- data_type_attribute
{ { UPPERCASE | UC } |
[NOT] { CASESPECIFIC | CS } |
FORMAT quotestring |
TITLE quotestring |
NAMED name |
DEFAULT { number | USER | DATE | TIME | NULL } |
WITH DEFAULT |
CHARACTER SET server_character_set
}
- QITS_attribute
{ column_name data_type column_attribute [...] |
column_constraint_attributes
}
- column_attribute
{ data_type_attribute [...] |
[NOT] NULL |
compression_attributes |
column_constraint_attributes |
column_identity_attributes |
}
- column_constraint_attributes
[ CONSTRAINT name ]
{ { UNIQUE | PRIMARY KEY } ( column_name [,...] ) | CHECK (boolean_condition ) }
- compression_attributes
COMPRESS [ { constant | NULL } | ( { constant | NULL } [,...] ) ]
- column_identity_attributes
GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( identity_attribute [...] ) ]
- identity_attribute
{ START WITH |
INCREMENT BY |
[NO] MINVALUE |
[NO] MAXVALUE |
[NO] CYCLE
}