Removing a search index
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;
Keyspace and table names are case-sensitive. Enclose names that contain uppercase in double quotation marks.