DROP WLM RULE ​

Drop a workload management (WLM) rule.

DROP WLM RULE [ IF EXISTS ] name

Only superusers and users who have been granted CONTROL WLM ON SYSTEM can create, alter, and drop WLM rules. When you drop a WLM profile, its associated resource pools and rules are dropped.

IF EXISTS

Do not return a warning if the rule does not exist.

name

The rule name must match the name of an existing rule in the database.

For example:

premdb=# drop wlm rule freeway;
DROP WLM RULE

Query the sys.wlm_pending_rule view to see the current rules in the system.

Note: System rules, which begin with the sys. prefix, cannot be dropped.

Parent topic:SQL Commands