DROP CONCURRENT_LIMITING_RULE

Purpose

This statement is used to delete a throttling rule.

Limitations and considerations

To execute the DROP CONCURRENT_LIMITING_RULE statement in OceanBase Database in Oracle mode, you must have the drop any concurrent_limiting_rule privilege.

Syntax

DROP CONCURRENT_LIMITING_RULE [ IF EXISTS ] "ccl_rule_name1" [, "ccl_rule_name2", ...]

Here, ccl_rule_name specifies the name of the throttling rule.

Examples

Execute the following statement to delete the throttling rules sql1_keywords_ccl_rule and sql2_keywords_ccl_rule:

obclient> DROP CONCURRENT_LIMITING_RULE "sql1_keywords_ccl_rule", "sql2_keywords_ccl_rule";