The form of the Drop Index statement is:

DROP INDEX table_name.index_name

table_name is the name of the table from which the index is to be dropped.

index_name is the name of the index.

For example:

DROP INDEX emp.lname