Small. Fast. Reliable.
Choose any three.
DROP INDEX

drop-index-stmt:

DROP INDEX IF EXISTS schema-name . index-name

R-42037-15614:[The DROP INDEX statement removes an index added with the CREATE INDEX statement. ] The index is completely removed from the disk. The only way to recover the index is to reenter the appropriate CREATE INDEX command.