Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ SQL Reference/ SQL Syntax/ DROP INDEX
Updated on 2025-02-27 GMT+08:00
View PDF
Share

DROP INDEX

Description

Drops an index.

Precautions

Only the index owner, a user of a schema where the index resides, or a user who has the INDEX permission on the table where the index resides can run the DROP INDEX command. System administrators have this permission by default.

Syntax

1
2
 
DROP INDEX [ IF EXISTS ] 
    index_name [, ...] [ CASCADE | RESTRICT ];

Parameters

  • IF EXISTS

    Reports a notice instead of an error if the specified index does not exist.

  • index_name

    Specifies the name of the index to be dropped.

    Value range: name of an existing index.

  • CASCADE | RESTRICT
    • CASCADE: automatically drops the objects that depend on the index.
    • RESTRICT: refuses to drop the index if any objects depend on it. This is the default action.

Examples

See Examples in "CREATE INDEX."

Helpful Links

ALTER INDEX and CREATE INDEX

Parent topic: SQL Syntax