DROP INDEX Statement

The DROP INDEX removes the specified index from the database.

Syntax

drop_index_statement ::= 
   DROP INDEX [IF EXISTS] index_name ON table_name

Semantics

If an index with the given name does not exist, then the statement fails, and an error is reported.

If the optional IF EXISTS clause is used in the DROP INDEX statement, and if an index with the same name does not exist, then the statement will not execute, and no error is reported.