DROP INDEX
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;
See also