DROP INDEX

❗️

This is a legacy Apache Ignite documentation

The new documentation is hosted here: https://ignite.apache.org/docs/latest/

Drop an index on the specified table.

DROP INDEX [IF EXISTS] indexName

Parameters

• indexName - the name of the index to drop.
• IF EXISTS - do not throw an error if an index with the specified name does not exist. The database checks indexes' names only not considering columns types or count.

Description

DROP INDEX command removes a previously created index.

DDL commands targeting the same table are blocked until the DROP INDEX is in progress. DML commands execution is not affected and can be performed in parallel.

Schema changes applied by this command are persisted on disk if Ignite persistence is enabled. Thus, the changes can survive full cluster restarts.

Examples

Drop an index:

DROP INDEX idx_person_name;

See Also

CREATE INDEX