DROP INDEX removes the specified index.
DROP INDEX index-Name
DROP INDEX OrigIndex DROP INDEX DestIndex
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.