The syntax for DROP INDEX in BNF is as follows:

Syntax

drop index statement ::= 
 DROP INDEX  [ index_owner_name . ]  index_name 
    [  ON  [ table_owner_name . ] table_name ]

For more information, see DROP INDEX.