Updated on 2024-09-02 GMT+08:00

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

  • IF EXISTS

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

  • rule_name

    Indicates the name of the exception rule set.

    Value range: a string of 1 to 64 characters. It must comply with the naming convention.

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;