Background documentationDROP INDEX Statement (drop_index_statement) Locate this document in the navigation structure


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


Syntax Syntax

  1. <drop_index_statement> ::=
      DROP INDEX <index_name> [ON <table_name>]
End of the code.

SQL Tutorial, Indexes


If a schema name is not specified in the table name, the current schema is used.

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 database user must be the owner of the specified table or have the INDEX privilege for it.

More Information

Privileges: Overview