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