Help Center/ GaussDB(DWS)/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ DROP EXCEPT RULE
Updated on 2025-07-22 GMT+08:00
View PDF
Share

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

Remove the rule set named except_rule1:

1
 
DROP EXCEPT RULE except_rule1;

Remove the rule set named except_rule2 if it exists:

1
 
DROP EXCEPT RULE IF EXISTS except_rule2;

Links

CREATE EXCEPT RULE, ALTER EXCEPT RULE

Parent Topic: DDL Syntax