Help Center/ Data Warehouse Service / SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ DROP BLOCK RULE
Updated on 2025-09-18 GMT+08:00
View PDF

DROP BLOCK RULE

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

1
 
DROP BLOCK RULE [ IF EXISTS ] block_name;

Parameter Description

Table 1 DROP BLOCK RULE parameters

Parameter

Description

Value Range

IF EXISTS

Sends a message instead of an error if the specified query filtering rule does not exist.

-

block_name

Name of the query filtering rule to be deleted.

The value must be an existing filter rule name.

Examples

Delete a query filtering rule named query_block.

1
2
 
DROP BLOCK RULE query_block;
DROP BLOCK RULE IF EXISTS query_block;
Parent Topic: DDL Syntax