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.

Example 8-21 Drop index

DROP INDEX idx_income1 ON UserInfo

Output:

Statement completed successfully