DROP INDEX command

This command removes an index from a base table.

Syntax

DROP INDEX index_name;

Keyword	Description
`index_name`	Name of the index to remove

Use

This statement is used to remove an index and can be used currently only before the table is accessed the first time by a non-DDL statement (which causes the physical file to be created).

Example

DROP INDEX STAFF_IX1