SQL Guide
:
Using SQL for database administration
:
Managing indexes
: Deleting an index
Deleting an index
DROP INDEX
index_name
;
The following example deletes the index named X_TEST.
DROP INDEX X_TEST;
Note
After creating or dropping an index, you must commit (or roll back) your work before you can modify the data in the table on which you created or dropped the index.
See also
Managing indexes
This site works best with JavaScript enabled