Name

DROP INDEX — Delete a table index from a database

Syntax

Common Usage

DROP INDEX database_name.index_name;

Description

The DROP INDEX command deletes an explicitly created index. The index and all the data it contains is deleted from the database. The table the index references is not modified. You cannot drop automatically generated indexes, such as those that enforce unique constraints declared in table definitions.

Dropping an index that does not exist normally generates an error. If the optional IF EXISTS clause is provided, this error is silently ignored.

See Also

CREATE INDEX, CREATE TABLE, DROP TABLE