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

Syntax

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