DROP INDEX

This page documents a preview version. v2.23 Preview

Preview includes features under active development and is for development and testing only.
For production, use the latest stable version (v2024.1).

Synopsis

Use the DROP INDEX statement to remove an index and all of its data from the database.

drop_index ::= DROP INDEX [ IF EXISTS ] index_name;

Where

An error is raised if the specified index_name does not exist unless IF EXISTS option is present.
Associated objects to index_name such as prepared statements will be eventually invalidated after the drop statement is completed.

ycqlsh:example> CREATE TABLE users(id INT PRIMARY KEY, name TEXT) WITH transactions = { 'enabled' : true };

ycqlsh:example> CREATE INDEX users_by_name ON users(name);

ycqlsh:example> DROP INDEX users_by_name;