Drops a local or global secondary index from a table.
Drop a local secondary index
Use the same syntax as the MySQL DROP INDEX statement.
Drop a global secondary index
Syntax
DROP INDEX index_name ON tbl_nameindex_name is the name of the global secondary index to drop.