..) [CHARACTER SET charset_name] [Intercalar charset] | SET (valor1, valor2, valor3, ...) [CHARACTER SET charset_name] [Intercalar charset] | spatial_type La sintaxis de la index_col_name es: index_col_name: col_name [(longitud)] [ASC | DESC] La sintaxis de la index_type es: index_type: USO {BTREE | HASH} La sintaxis de la indexc_option es: index_option: KEY_BLOCK_SIZE [=] Valor | index_type | CON ANALIZADOR parser_name La sintaxis de la reference_definition es: reference_definition: Referencias tbl_name (index_col_name, ...
) [PARTIDO COMPLETO | Coincidencia parcial | SIMPLE PARTIDO] [ON reference_option DELETE] [ON reference_option ACTUALIZACIÓN] La sintaxis de la reference_option es: reference_option: RESTRINGEN | CASCADE | SET NULL | NO ACTION La sintaxis de la table_option es: table_options: table_option [[,] table_option] ...
table_option: MOTOR [=] engine_name | AUTO_INCREMENT [=] Valor | AVG_ROW_LENGTH [=] Valor | [DEFAULT] CHARACTER SET [=] charset_name | CHECKSUM [=] {0 | 1} | [DEFAULT] COLLATE [=] charset | COMENTARIO [=] 'cadena' | CONEXIÓN [=] 'connect_string' | DATOS DIRECTORIO [=] 'ruta absoluta al directorio' | DELAY_KEY_WRITE [=] {0 | 1} | ÍNDICE DE DIRECTORIO [=] 'ruta absoluta al directorio' | INSERT_METHOD [=] {NO | PRIMERA | ÚLTIMA} | KEY_BLOCK_SIZE [=] Valor | MAX_ROWS [=] Valor | MIN_ROWS [=] Valor | PACK_KEYS [=] {0 | 1 | DEFAULT} | CONTRASEÑA [=] 'cadena' | ROW_FORMAT [=] {DEFAULT | DINÁMICO | FIJO | COMPRIMIDO | REDUNDANTE | COMPACT} | TABLESPACE tablespace_name [{ALMACENAMIENTO DISCO | MEMORIA | DEFAULT}] | UNIÓN [=] (nombre_tabla [, tbl_name] .
..) La sintaxis de los partition_options es: partition_options: PARTITION BY {[LINEAL] HASH (expr) | [LINEAL] CLAVE (column_list) | GAMA (expr) | LISTA (expr)} [PARTICIONES num] [SUBPARTITION POR {[LINEAL] HASH (expr) | [LINEAL] CLAVE (column_list)} [subpartici