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
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.