This document corresponds to an earlier product version. Make sure you are using the version that corresponds to your version.
Latest Cassandra documentation | Earlier Cassandra documentation
Drops the named secondary index.
DROP INDEX <name>;
A DROP INDEX statement removes an existing secondary index. If the index was not given a name during creation, the index name is <columnfamily_name>_<column_name>_idx.
DROP INDEX user_state;
DROP INDEX users_zip_idx;