9.11.DROP INDEX Statement

        : DROP INDEX NAME opt_table

        : /* empty */
        | q_table_name

This will drop an index, dba privileges or table ownership are required. A table's primary key which has the same name as the table can not be dropped.

Optionally, a table name can be given if the index name is not unique. The table name may be qualified.