DROP INDEX

This statement removes an index from the database.

To support DROP INDEX processing, the IP GETSUPPORT operation must return TRUE for IP_SUPPORT_DROP_INDEX.

Syntax

DROP INDEX index_name

Example

DROP INDEX emp_i;