Cassandra DROP Index
DROP INDEX command is used to drop a specified index. If the index name was not specified during index creation, then index name is TableName_ColumnName_idx.
Rules for dropping an Index
Let's take an example to demonstrate how to drop index on a column. Here we drop the created index to a column "student_name" in the table "student". The name of the keyspace is "javatpoint".
Index is dropped from the column "student_name".
Note: You can verify that the index is dropped or not, by using the DROP index command once again. It will show a message that index is already dropped.
You can see that index is not anymore on the table.