|CQL reference / CQL commands|
Drop the named index.
DROP INDEX name
In the synopsis section of each statement, formatting has the following meaning:
A semicolon that terminates CQL statements is not included in the synopsis.
A DROP INDEX statement removes an existing index. If the index was not given a name during creation, the index name is <table_name>_<column_name>_idx.
DROP INDEX user_state; DROP INDEX users_zip_idx;