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.
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.