Purpose

The Drop Index statement drops an index for a local table.

Syntax

DROP INDEX index_name [IF EXISTS]

where:

index_name
specifies an existing index.
IF EXISTS
specifies that an error is not to be returned if the index does not exist. The Drop Index command generates an error if an index that is associated with a UNIQUE or FOREIGN KEY constraint is specified.

Notes

  • Indexes on a remote table cannot be dropped. Only indexes on local tables can be created, altered, and dropped.