Example: Dropping a Named Secondary Index
This request drops the existing named index index_1 from table table_5.
DROP INDEX index_1 ON table_5;
Example: Dropping a Simple Unnamed Secondary Index
This request drops a secondary index that was defined on the name column of the employee table.
DROP INDEX (name) ON Employee;
Example: Dropping a Composite Unnamed Secondary Index
This request drops the existing index on columns column_1 and column_2 from table table_6 .
DROP INDEX (column_1, column_2) ON table_6;