Use the DROP INDEX statement to drop an index.
DROP [ REVERSE ] [ UNIQUE ] INDEX index_name
[ON table_name] [ ; ]
- REVERSE: Specifies that the index to be dropped is a reverse index.
- UNIQUE: Specifies that the index to be dropped is a unique index.
- index_name: Specifies the name of the index to be dropped. If omitted, a name is automatically assigned as i_<table_name>_<column_names>.
- table_name: Specifies the name of the table whose index is to be dropped.
The following are examples of many ways of dropping indexes:
DROP INDEX game_date_idx ON game;
DROP REVERSE INDEX gold_index ON participant;