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

Example

ALTER TABLE a_tbl DROP INDEX i_a_tbl_age;