Lu, Huayi a24ca60074 DWS DEVELOPER 811 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2023-01-19 13:37:49 +00:00

5.0 KiB

Raw Permalink Blame History

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 ];

Parameter Description

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

Parent topic: DDL Syntax

5.0 KiB Raw Permalink Blame History