Apache Cassandra 1.1 Documentation
DROP INDEX¶
Drops the named secondary index.
Synopsis¶
DROP INDEX <name>;
Description¶
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.
Example¶
DROP INDEX user_state;
DROP INDEX users_zip_idx;
| CQL Commands | CQL Shell Commands |
|---|---|
| ALTER TABLE | ASSUME |
| ALTER KEYSPACE | CAPTURE |
| BATCH | COPY |
| CREATE TABLE | DESCRIBE |
| CREATE INDEX | EXIT |
| CREATE KEYSPACE | SHOW |
| DELETE | SOURCE |
| DROP TABLE | |
| DROP INDEX | |
| DROP KEYSPACE | |
| INSERT | |
| SELECT | |
| TRUNCATE | |
| UPDATE | |
| USE |