9.11. DROP INDEX Statement

drop_index
	: DROP INDEX NAME opt_table
	;

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.