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
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; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.