Updated on 2023-02-08 GMT+08:00

DROP INDEX

Function

DROP INDEX deletes an index.

Precautions

Only the owner of an index or a system administrator can run DROP INDEX command.

Syntax

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

Parameters

  • IF EXISTS

    Sends 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: automatically deletes all objects that depend on the index to be deleted.
    • RESTRICT (default): refuses to delete the index if any objects depend on it.

Examples

Delete the ds_ship_mode_t1_index2 index:

1
DROP INDEX tpcds.ds_ship_mode_t1_index2;

Helpful Links

ALTER INDEX, CREATE INDEX