Removing a search index

Drop a search index from a table and delete all related data.

Drop a search index from a table and delete all related data using the DROP SEARCH INDEX command.

The CQL syntax:
DROP SEARCH INDEX on [keyspace_name.]table_name;
Note: Keyspace and table names are case-sensitive. Enclose names that contain uppercase in double quotation marks.