DROP INDEX

This command drops existed indexed specified by its name.

Syntax

drop_index
    :    DROP INDEX index_name ON table_name