Drop Index

Purpose

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.