DROP CONCURRENT_LIMITING_RULE

Purpose

This statement is used to delete a throttling rule.

Privilege requirements

To execute the DROP CONCURRENT_LIMITING_RULE statement, the current user must have the DROP privilege. For more information about OceanBase Database privileges, see Privilege types in MySQL-compatible mode.

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 command to delete the throttling rules sql1_keywords_ccl_rule and sql2_keywords_ccl_rule.

obclient> DROP ONCURRENT_LIMITING_RULE `sql1_keywords_ccl_rule`, `sql2_keywords_ccl_rule`;