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.