DROP INDEX { index_specification | index_definition } [;]
- index_specification
[ database_name. ] index_name ON { table_specification | join_index_specification }
- index_definition
{ ( column_name [,...] ) | [ database_name. ] index_name } [ order_clause ] ON { table_specification | join_index_specification }- table_specification
[ TEMPORARY ] [ database_name. ] table_name
- join_index_specification
[ database_name. ] join_index_name
- order_clause
ORDER BY [ VALUES | HASH ] ( column_name_2 )