DROP INDEX Statement (drop_index_statement) Locate the document in its SAP Library structure

The DROP INDEX statement drops an index for a base table (see table). The metadata of the index is dropped from the database catalog. The storage space occupied by the index is released.

Syntax

<drop_index_statement> ::= DROP INDEX <index_name> [ON <table_name>]

index_name, table_name

Explanation

The specified index must exist and the specified table name must be the name of an existing base table.

ON <table name> is not necessary if the index name identifies an index unambiguously.

The current user must be the owner of the specified table or have the INDEX privilege for it.