Small. Fast. Reliable.
Choose any three.

drop-index-stmt

DROP INDEX IF EXISTS schema-name . index-name

Used by:   sql-stmt

See also:   lang_dropindex.html