DROP CONCURRENT_LIMITING_RULE

Description

This statement is used to drop a concurrent limiting rule.

Privilege requirements

To execute the DROP CONCURRENT_LIMITING_RULE statement, the current user must have the DROP privilege. For more information about the privileges of seekdb, see Privilege classification of seekdb.

Syntax

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

Here, ccl_rule_name specifies the name of the concurrent limiting rule.

Examples

info

When a concurrent limiting rule is dropped, the rule immediately becomes invalid. All SQL statements in the waiting queue under this rule will be executed normally.

Execute the following command to drop the concurrent limiting rules sql1_keywords_ccl_rule and sql2_keywords_ccl_rule:

DROP ONCURRENT_LIMITING_RULE `sql1_keywords_ccl_rule`，`sql2_keywords_ccl_rule`;