{ 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 ) ]