DROP INDEX
Function
This statement removes an index from a table.
Syntax
DROP INDEX index_specification
where

index_specification | the index_spericication for CONNX has the following special format: [CONNX table-name]_INDEX_[CONNX index-number]

Description
The specified index is removed from the specified base table.
If the statement is invoked statically, then during pre-compilation, the schema need not exist in the catalog. For successful execution, however, the schema must exist in the catalog, regardless of how it is invoked.
Limitations
DROP INDEX is not supported by VSAM, Codasyl, DBMS, or IMS.
ANSI Specifics
This statement is not part of the Standard.
Examples
DROP INDEX customers_INDEX_1