Drop a SSTable-attached secondary index (SASI) SASI indexes can be dropped (deleted). Prerequisites Keyspace created Table created To drop a SASI index: DROP INDEX IF EXISTS cycling.name_sasi_idx;