This command drops existed indexed specified by its name.
drop_index : DROP INDEX index_name ON table_name