{ CREATE table_kind TABLE | CT } table_specification
[ table_option [,...] ]
( attribute [,...] )
AS_clause
[ , index [[,]...] ]
[ table_preservation ][;]
-
table_kind
-
[ SET | MULTISET ] [ GLOBAL TEMPORARY | VOLATILE ]
-
table_specification
-
[ database_name. | user_name. ] table_name
-
table_option
-
{ MAP = map_name [COLOCATE USING colocation_name |
[NO] FALLBACK [PROTECTION] |
WITH JOURNAL TABLE = table_specification |
[NO] LOG |
[ NO | DUAL ] [BEFORE] JOURNAL |
[ NO | DUAL | LOCAL | NOT LOCAL ] AFTER JOURNAL |
CHECKSUM = { DEFAULT | ON | OFF } |
FREESPACE = integer [PERCENT] |
mergeblockratio |
datablocksize |
blockcompression |
isolated_loading
}
-
attribute
-
{ column_specification |
[ COLUMN | ROW ] ( column_specification [,...] ) [ [NO] AUTOCOMPRESS ] |
table_constraint
}
-
AS_clause
-
AS source_table [ subquery_clause ] WITH [NO] DATA [ AND [NO] STATISTICS ]
-
index
-
[UNIQUE] PRIMARY INDEX [index_name] ( index_column_name [,...] ) |
NO PRIMARY INDEX |
PRIMARY AMP [INDEX] [index_name] ( index_column_name [,...] ) |
PARTITION BY { partitioning_level | ( partitioning_level [,...] ) } |
UNIQUE INDEX [ index_name ] [ ( index_column_name [,...] ) ] [loading] |
INDEX [index_name] [ALL] ( index_column_name [,...] ) [ordering] [loading]
[,...]
-
table_preservation
-
ON COMMIT { DELETE | PRESERVE } ROWS
-
mergeblockratio
-
{ DEFAULT MERGEBLOCKRATIO |
MERGEBLOCKRATIO = integer [PERCENT] |
NO MERGEBLOCKRATIO
}
-
datablocksize
-
DATABLOCKSIZE = {
data_block_size [ BYTES | KBYTES | KILOBYTES ] |
{ MINIMUM | MAXIMUM | DEFAULT } DATABLOCKSIZE
}
-
blockcompression
-
BLOCKCOMPRESSION = { AUTOTEMP | MANUAL | ALWAYS | NEVER | DEFAULT }
[, BLOCKCOMPRESSIONALGORITHM = { ZLIB | ELZS_H | DEFAULT } ]
[, BLOCKCOMPRESSIONLEVEL = { value | DEFAULT } ]
-
isolated_loading
-
WITH [NO] [CONCURRENT] ISOLATED LOADING [ FOR { ALL | INSERT | NONE } ]
-
subquery_clause
-
AS source_table WITH [NO] DATA [ AND [NO] STATISTICS ]
-
column_specification
-
column_name [ column_data_type_attribute [...] ]
-
partitioning_level
-
{ partitioning_expression |
COLUMN [ [NO] AUTO COMPRESS |
COLUMN [ [NO] AUTO COMPRESS ] [ ALL BUT ] column_partition ]
} [ ADD constant ]
-
loading
-
WITH [NO] LOAD IDENTITY
-
ordering
-
ORDER BY [ VALUES | HASH ] [ ( order_column_name ) ]
-
column_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 |
[NOT] NULL |
[NOT] AUTO COLUMN |
compression_attribute |
column_constraint_attribute |
identity_column
}
-
compression_attribute
-
{ NO COMPRESS |
COMPRESS [ constant | ( { constant | NULL } [,...] ) ] |
COMPRESS USING compress_UDF_name DECOMPRESS
USING decompress_UDF_name
}
-
column_constraint_attribute
-
[ CONSTRAINT constraint_name ]
{ UNIQUE | PRIMARY KEY | CHECK ( boolean_condition ) | references } |
[ row_level_security_constraint_column_name [,...] ] CONSTRAINT
-
identity_column
-
GENERATE {ALWAYS | BY DEFAULT} AS IDENTITY
[ ( START WITH constant |
INCREMENT BY constant |
MINVALUE constant |
NO MINVALUE |
MAXVALUE constant |
NO MAXVALUE |
[ NO ] CYCLE ) ]