skip to main content
SQL statements : DDL statements : DROP INDEX
 

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;