Function

This statement removes an index from a table.

 

 

Syntax

 

 

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.

 

ANSI Specifics

This statement is not part of the Standard.

 

CONNX Specifics

None.

 

Example

DROP INDEX customers_INDEX_1

 

Note: DROP INDEX is not supported by VSAM, Codasyl,DBMS or IMS.