Help Center/ Data Warehouse Service/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ Resource Pools and Filtering Rules/ DROP EXCEPT RULE
Updated on 2026-05-29 GMT+08:00
View PDF

DROP EXCEPT RULE

Function

This syntax deletes a specified exception rule set.

Precautions

Only the system administrator can perform the DROP EXCEPT RULE operation.

Syntax

1
2
 
DROP EXCEPT RULE [ IF EXISTS ] 
    rule_name ;

Parameter Description

Table 1 DROP EXCEPT RULE parameters

Parameter

Description

Value Range

IF EXISTS

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

-

rule_name

Indicates the name of the exception rule set.

Name of an existing exception rule set.

Examples

Create exception rule set except_rule_1.

1
 
CREATE EXCEPT RULE except_rule_1 WITH (blocktime=2000, spillsize=3000, action=abort);

Delete rule set except_rule_1.

1
 
DROP EXCEPT RULE except_rule_1;

Delete rule set except_rule_2 if it exists.

1
 
DROP EXCEPT RULE IF EXISTS except_rule_2;

Links

CREATE EXCEPT RULE, ALTER EXCEPT RULE

Parent Topic: Resource Pools and Filtering Rules