SQL Drop Index Statement

Removes an index and all its contents.

Syntax

DROP INDEX table_name.index_name
table_name:  table to which the index belongs
index_name:  name of the index to drop

Example


drop index persons.age