This topic describes how to use the DROP INDEX statement to delete a local secondary index (LSI) and a global secondary index (GSI).

LSI

LSIs in Distributed Relational Database Service (DRDS) can be deleted by using the same method that is used to delete LSIs in MySQL databases. For more information, see DROP INDEX.

GSI

Syntax

# The index_name parameter is the name of the GSI that you want to delete. 
DROP INDEX index_name ON tbl_name