Apache Ignite SQL Documentation

The Apache Ignite SQL Developer Hub

Welcome to the Apache Ignite SQL developer hub. You'll find comprehensive guides and documentation to help you start working with Apache Ignite SQL as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

DROP INDEX

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

Updated less than a minute ago

DROP INDEX


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.