DROP INDEX Clause
Description
You can delete an index defined for a column by using the DROP INDEX clause.
Syntax
ALTER [ TABLE | CLASS ] table_name DROP INDEX index_name
- table_name : Specifies the name of a table that has an index attribute to be deleted.
- index_name : Specifies the name of an index to be deleted.
Example
ALTER TABLE a_tbl DROP INDEX i_a_tbl_age;