Use the DROP INDEX statement to drop an index. There are the following two ways to specify the index to be dropped:
DROP [ REVERSE ] [ UNIQUE ] INDEX index_name
[ON table_name ( column_name [ {, column_name } ...) ] [ ]
DROP [ REVERSE ] [ UNIQUE ] INDEX
ON table_name ( column_name [ {, column_name } ...) [ ]
The following are examples of many ways of dropping indexes:
DROP INDEX ON game(medal);
DROP INDEX game_date_idx;
DROP REVERSE INDEX gold_index ON participant(gold);
DROP INDEX name_nation_idx ON athlete(name, nation_code);