DROP INDEX statementThe DROP INDEX statement removes the specified index.DROP INDEX statement
An index is created by a .
SyntaxDROP INDEX indexNameExamplesDROP INDEX OrigIndex
DROP INDEX DestIndexStatement dependency system
If there
is an open cursor on the table from which the index is dropped, the DROP INDEX
statement generates an error and does not drop the index. Otherwise, statements
that depend on the index's table are invalidated.