Drop Index 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