Drop Index

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

Grammar

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.

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