DROP INDEX

DROP INDEX

DITA

DROP INDEX index_name

DROP INDEX[[catalog_name.]schema_name.]index_name

Usage

The DROP INDEX statement removes the specified index from the database. Primary key indexes cannot be removed.

Examples

DROP INDEX test_index;
-- Using catalog, schema, and index name
DROP INDEX bank_accounts.bankteller.first_name_index;