) [Tegnsett charset_name] [Sorter collation_name] | spatial_type Syntaksen for index_col_name er: index_col_name: col_name [(lengde)] [ASC | DESC] Syntaksen for index_type er: index_type: BRUKE {BTREE | HASH} Syntaksen for indexc_option er: index_option: KEY_BLOCK_SIZE [=] verdi | index_type | MED parser parser_name Syntaksen for reference_definition er: reference_definition: REFERANSER tbl_name (index_col_name, ...
) [MATCH FULL | MATCH DELVIS | MATCH SIMPLE] [ON DELETE reference_option] [ON UPDATE reference_option] Syntaksen for reference_option er: reference_option: BEGRENSER | CASCADE | SET NULL | NO ACTION Syntaksen for table_option er: table_options: table_option [[,] table_option] ... table_option: MOTOR [=] ENGINE_NAME | AUTO_INCREMENT [=] verdi | AVG_ROW_LENGTH [=] verdi | [STANDARD] KARAKTER SET [=] charset_name | CHECKSUM [=] {0 | 1} | [STANDARD] SORTER [=] collation_name | KOMMENTAR [=] 'streng' | FORBINDELSE [=] 'connect_string' | Datakatalogen [=] 'absolutte stien til katalogen' | DELAY_KEY_WRITE [=] {0 | 1} | INDEX DEBATT [=] 'absolutte stien til katalogen' | INSERT_METHOD [=] {NO | FIRST | LAST} | KEY_BLOCK_SIZE [=] verdi | MAX_ROWS [=] verdi | MIN_ROWS [=] verdi | PACK_KEYS [=] {0 | 1 | STANDARD} | PASSORD [=] 'streng' | ROW_FORMAT [=] {DEFAULT | DYNAMISK | FIKSET | KOMPRIMERT | REDUNDANT | COMPACT} | TABLEtabell [OPPBEVARING {DISK | MEMORY | DEFAULT}] | UNION [=] (tbl_name [, tbl_name] .
..) Syntaksen for partition_options er: partition_options: PARTITION BY {[LINEAR] HASH (expr) | [LINEAR] KEY (column_list) | RANGE (expr) | LIST (expr)} [partisjoner num] [SUBPARTITION BY {[LINEAR] HASH (expr) | [LINEAR] KEY (column_list)} [SUBPARTITIONS num]] [(partition_definition [, partition_definition] ...)] Syntaksen for partition_definition alternativet er: partition_definition: -partisjonen partisjons [VERDIER {MINDRE ENN {(expr) | MAXVALUE} | IN (value_list)}] [[Storage] MOTOR [