..) [TEKENSET charset_name] [Sorteren collation_name] | SET (waarde1, waarde2, waarde3, ...) [TEKENSET charset_name] [Sorteren collation_name] | spatial_type De syntaxis voor de index_col_name is: index_col_name: col_name [(lengte)] [ASC | DESC] De syntaxis voor de index_type is: index_type: GEBRUIK {btree | HASH} De syntaxis voor de indexc_option is: index_option: KEY_BLOCK_SIZE [=] waarde | index_type | MET PARSER parser_name De syntaxis voor de reference_definition is: reference_definition: Referenties tbl_name (index_col_name, ...
) [MATCH VOLLEDIGE | MATCH GEDEELTELIJKE | MATCH SIMPLE] [ON DELETE reference_option] [ON UPDATE reference_option] De syntaxis voor de reference_option is: reference_option: RESTRICT | CASCADE | SET NULL | GEEN ACTIE De syntaxis voor de table_option is: table_options: table_option [[,] table_option] ...
table_option: ENGINE [=] engine_name | AUTO_INCREMENT [=] waarde | AVG_ROW_LENGTH [=] waarde | [STANDAARD] TEKENSET [=] charset_name | CHECKSUM [=] {0 | 1} | [STANDAARD] COLLATE [=] collation_name | COMMENT [=] 'string' | CONNECTION [=] 'connect_string' | DATA directory [=] "absolute pad naar de directory '| DELAY_KEY_WRITE [=] {0 | 1} | INDEX directory [=] "absolute pad naar de directory '| INSERT_METHOD [=] {NO | Eerste | LAATSTE} | KEY_BLOCK_SIZE [=] waarde | MAX_ROWS [=] waarde | MIN_ROWS [=] waarde | PACK_KEYS [=] {0 | 1 | STANDAARD} | PASSWORD [=] 'string' | ROW_FORMAT [=] {Standaard | DYNAMIEK | FIXED | SAMENGEPERST | REDUNDANTE | COMPACT} | TABLESPACE tablespace_name [OPSLAG {DISK | MEMORY | default}] | UNION [=] (tbl_name [, tbl_name] .
..) De syntaxis voor de partition_options is: partition_options: PARTITION BY {[LINEAR] HASH (expr) | [LINEAR] KEY (column_list) | RANGE (expr) | LIST (expr)} [PARTITIES num] [subpartitie DOOR {[LINEAR] HASH (expr) | [LINEAR] KEY (column_list)} [SUBPARTI