DROP BLOCK RULE

Updated on 2024-09-30 GMT+08:00

View PDF

Function

Delete a query filtering rule.

This syntax is supported only by clusters of 9.1.0.100 and later versions.

Precautions

Only a user with the database owner permission or the gs_role_block role permission can run the DROP BLOCK RULE command. A system administrator has this permission by default.

Syntax

    
       DROP BLOCK RULE [ IF EXISTS ] block_name;

Parameter Description

IF EXISTS
Sends a notice instead of an error if the specified query filtering rule does not exist.
block_name
Name of the query filtering rule to be deleted.

Value range: a string, which indicates the name of an existing query filtering rule.

Example

Delete a query filtering rule named query_block.

    
       DROP BLOCK RULE query_block;
DROP BLOCK RULE IF EXISTS query_block;

Parent topic: DDL Syntax

Previous topic: DISCARD

Next topic: DROP DATABASE

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.

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