On this page

Function
Precautions
Syntax
Parameter Description
Examples
Helpful Links

Show all

Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ SQL Reference/ SQL Syntax/ DROP INDEX

DROP INDEX

Updated on 2024-05-21 GMT+08:00

View PDF

Function

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. The system administrator has this permission by default.

Syntax

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

Parameter Description

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

Parent topic: SQL Syntax

Previous topic: DROP GROUP

Next topic: DROP LANGUAGE

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback

Log In and Submit Submit Cancel