DROP INDEX

DROP INDEX IF EXISTS ArtistNameIdx;
Loading console...

drop-index-stmt:

DROP INDEX IF EXISTS schema-name . index-name

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.