All Products
Search

This Product

    PolarDB:DROP INDEX

    Document Center

    PolarDB:DROP INDEX

    Last Updated:Mar 28, 2026

    Removes a local secondary index (LSI) or a global secondary index (GSI) from a table.

    LSI

    Distributed Relational Database Service (DRDS) follows the same DROP INDEX syntax as MySQL for removing LSIs. See DROP INDEX in the MySQL 5.7 Reference Manual.

    GSI

    Syntax

    DROP INDEX index_name ON tbl_name

    Parameters

    ParameterDescription
    index_nameThe name of the GSI to drop.
    tbl_nameThe name of the table that contains the GSI.