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

Examples

Delete a query filtering rule named query_block.

1
2

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