Updated on 2025-03-13 GMT+08:00

DROP INDEX

Description

Drops an index.

Precautions

Only the index owner, owner of the schema where the index resides, a user who has the INDEX permission on the table where the index resides, or a user who has the DROP ANY INDEX permission 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 deleted.

    Value range: an existing index

  • CASCADE | RESTRICT
    • CASCADE: cascadingly deletes the objects that depend on the index.
    • RESTRICT: refuses to delete the index if any objects depend on it. This is the default action.

Examples

See Examples in section "CREATE INDEX."

Helpful Links

ALTER INDEX and CREATE INDEX