DROP INDEX

On this page

Removes an index from a table. The table’s rows are retained, but queries can no longer use that index.

Syntax

DROP INDEX [ IF EXISTS ] <name> ON <table_name>

<name> identifies the index within the specified table. IF EXISTS skips the operation if the index is missing.

Examples

After running the CREATE INDEX examples, remove the event-ID index:

DROP INDEX idx_event_id ON indexed_requests

Use IF EXISTS when cleanup may run more than once:

DROP INDEX IF EXISTS idx_event_id ON indexed_requests