DROP INDEX statement

The DROP INDEX statement removes the specified index.

An index is created by a CREATE INDEX statement.

Syntax

DROP INDEX indexName

Examples

DROP INDEX OrigIndex

DROP INDEX DestIndex

Statement dependency system

If there is an open cursor on the table from which the index is dropped, the DROP INDEX statement generates an error and does not drop the index. Otherwise, statements that depend on the index's table are invalidated.