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.
Syntax:
DROP INDEX
Or
Polymorphism in Java | Dynamic Method Dispatch
Drop index IF EXISTS KeyspaceName.IndexName
Rules for dropping an Index
- If the index does not exist, it will return an error unless you use IF EXISTS which returns no operation.
- During index creation, you have to specify keyspace name with the index name otherwise index will be dropped from the current keyspace.
Example:
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".
Drop index IF EXISTS javatpoint.student_name
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.
