INT_ VALUE
one hundred and twenty-three
DECIMAL_ VALUE
one hundred and twenty-three point four five six
STR_ VALUE
abc
NULL
STORAGE_ SIZE
one thousand and twenty-four
'500M'
const_ value: INT_ VALUE | DECIMAL_ VALUE | STR_ VALUE | NULL | STORAGE_ SIZE STORAGE_ SIZE: INT_ VALUE | 'INT_ VALUE[M|G]'
charset: default_ charset | column_ charset default_ charset: [DEFAULT] {CHARSET | CHARACTER SET} [=] {UTF8 | UTF8MB4 | BINARY} column_ charset: {CHARSET | CHARACTER SET} {UTF8 | UTF8MB4 | BINARY}
collate: default_ collate | column_ collate default_ collate: [DEFAULT] COLLATE [=] {UTF8MB4_GENERAL_CI | UTF8MB4_BIN | BINARY} column_ collate: COLLATE {UTF8MB4_GENERAL_CI | UTF8MB4_BIN | BINARY}
data_ type: TINYINT[(precision)] [UNSIGNED] [ZEROFILL] | SMALLINT[(precision)] [UNSIGNED] [ZEROFILL] | MEDIUMINT[(precision)] [UNSIGNED] [ZEROFILL] | INT[(precision)] [UNSIGNED] [ZEROFILL] | INTEGER[(precision)] [UNSIGNED] [ZEROFILL] | BIGINT[(precision)] [UNSIGNED] [ZEROFILL] | FLOAT[(precision, scale)] [UNSIGNED] [ZEROFILL] | DOUBLE[(precision, scale)] [UNSIGNED] [ZEROFILL] | DECIMAL[(precision [, scale])] [UNSIGNED] [ZEROFILL] | NUMERIC[(precision [, scale])] [UNSIGNED] [ZEROFILL] | DATETIME[(scale)] | TIMESTAMP[(scale)] | DATE | TIME[(scale)] | YEAR | VARCHAR(length) column_ charset column_ collate | VARBINARY(length) | CHAR[(length)] column_ charset column_ collate | BINARY[(length)] | TINYTEXT column_ charset column_ collate | TINYLOB | TEXT[(length)] column_ charset column_ collate | BLOB[(length)] | MEDIUMTEXT column_ charset column_ collate | MEDIUMBLOB | LONGTEXT column_ charset column_ collate | LONGBLOB precision | scale | length: INT_ VALUE
tenant_ name | pool_ name | unit_ name | zone_ name | region_ name: STR_ VALUE database_ name | table_ name | table_ alias_ name | column_ name| column_ alias_ name | partition_ name | subpartition_ name: STR_ VALUE index_ name | view_ name | object_ name | constraint_ name | tablegroup_ name: STR_ VALUE outline_ name | user_ name: STR_ VALUE table_ factor: [[database_name].] table_ name column_ factor: [table_factor.] column_ name
expression: const_ value | column_ factor | operator_ expression | function_ expression
comment : COMMENT 'comment_ text' comment_ text: STR_ VALUE
PRIMARY_ ZONE
primary_ zone: PRIMARY_ ZONE [=] zone_ name
ZONE_ LIST
zone_ list: ZONE_ LIST [=] (zone_name [, zone_name ...])
REPLICA_ NUM
replica_ num: REPLICA_ NUM [=] INT_ VALUE
TABLEGROUP
tablegroup: default_ tablegroup | table_ tablegroup default_ tablegroup: DEFAULT TABLEGROUP [=] {tablegroup_name | NULL} table_ tablegroup: TABLEGROUP [=] {tablegroup_name | NULL}
BLOCK_ SIZE
block_ size: BLOCK_ SIZE [=] INT_ VALUE
COMPRESSION
compression: COMPRESSION [=] {NONE | LZ4_1.0 | LZ0_1.0 | SNAPPY_1.0 | ZLIB_1.0}
PCTFREE
pctfree: PCTFREE [=] INT_ VALUE
TABLET_ SIZE
tablet_ size: TABLET_ SIZE [=] INT_ VALUE