DROP INDEX

Description

Use the DROP INDEX statement to drop an index.

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} ...) [ ; ]

• REVERSE: Specifies that the index to be dropped is a reverse index.
• UNIQUE: Specifies that the index to be dropped is a unique index. This can be dropped with DROP CONSTRAINT clause.
• 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.
• column_name: Specifies the name of the column whose index is to be dropped.

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