DROP INDEX

Description

Use the DROP INDEX statement to drop an index. There are the following two ways to specify the index to be dropped:

Syntax

DROP [ REVERSE ] [ UNIQUE ] INDEX index_name

[ON table_name ( column_name [ {, column_name } ...) ] [   ]

 

DROP [ REVERSE ] [ UNIQUE ] INDEX

  ON table_name ( column_name [ {, column_name } ...) [ ]

Example

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);