# 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.

Parent topic: DROP statements
Related reference
DROP DERBY AGGREGATE statement
DROP FUNCTION statement
DROP PROCEDURE statement
DROP ROLE statement
DROP SCHEMA statement
DROP SEQUENCE statement
DROP SYNONYM statement
DROP TABLE statement
DROP TRIGGER statement
DROP TYPE statement
DROP VIEW statement