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