All Products
Search
Document Center

DROP INDEX

Last Updated: Aug 18, 2020

This topic describes how to delete local indexes and global secondary indexes (GSIs) in Distributed Relational Database Service (DRDS) by executing the DROP INDEX statement.

Local index

The method for deleting a local index in DRDS is the same as that in MySQL. For more information, see MySQL DROP INDEX Statement.

GSI

Syntax:

  1. DROP INDEX index_name ON tbl_name

The index_name parameter indicates the name of the GSI that you want to delete.