You can execute the DROP INDEX statement to delete local and global secondary indexes.

Delete a local secondary index

Local secondary indexes can be deleted by using the same method that is used to delete local secondary indexes in MySQL databases. For more information, see DROP INDEX statement.

Delete a global secondary index


DROP INDEX index_name ON tbl_name      
Note index_name specifies the name of the global secondary index that you want to delete.