DROP INDEX Clause
You can delete an index defined for a column by using the DROP INDEX clause.
ALTER [ TABLE | CLASS ] table_name DROP [ REVERSE ] [ UNIQUE ] INDEX index_name
- REVERSE: Specifies that the index to be dropped is a reverse index.
- UNIQUE: Specifies that the index to be dropped is a unique index. The unique index can be dropped by using the DROP CONSTRAINT statement.
- table_name: Specifies the name of a table of which constraints will be deleted.
- index_name: Specifies the name of an index to be deleted.
ALTER TABLE a_tbl DROP INDEX i_a_tbl_age;