DROP INDEX
DROP INDEX [[catalog‑name.]schema‑name.]index‑name
Access requirements
Table creator or users that have the SYS_ADMIN_ROLE role
Usage
Use the DROP INDEX statement to remove the specified index from the database. Primary key indexes cannot be removed.
After you drop an index, you must commit (or roll back) your work before you can modify the data in the table on which you dropped the index.
Examples
DROP INDEX test_index;
-- Using catalog, schema, and index name
DROP INDEX bank_accounts.bankteller.first_name_index;
Go up to