DROP INDEX

Description

Use the DROP INDEX statement to drop an index.

Syntax

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.

Example

The following are examples of many ways of dropping indexes:

DROP INDEX game_date_idx ON game;

DROP REVERSE INDEX gold_index ON participant;