DROP INDEX statement 

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

Syntax

<drop index statement> ::=
  DROP INDEX <table name>.<column name>
| DROP INDEX <index name> [ON <table name>]

table name, column name, index 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.