DROP INDEX
Attention
This page documents an earlier version. Go to the latest (v2.3) version.Synopsis
Use the DROP INDEX
statement to remove an index and all of its data from the database.
Syntax
Diagram
Grammar
drop_index ::= DROP INDEX [ IF EXISTS ] index_name;
Where
index_name
is an identifier (possibly qualified with a keyspace name).
Semantics
- An error is raised if the specified
index_name
does not exist unlessIF EXISTS
option is present. - Associated objects to
index_name
such as prepared statements will be eventually invalidated after the drop statement is completed.
Examples
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;