DROP EXCEPT RULE

This syntax deletes a specified exception rule set.

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

 DROP EXCEPT RULE [ IF EXISTS ] 
    rule_name ;
 

**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.

Remove the rule set named except_rule1:

 DROP EXCEPT RULE except_rule1;
 

Remove the rule set named except_rule2 if it exists:

 DROP EXCEPT RULE IF EXISTS except_rule2;
 

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.