DROP WORKLOAD GROUP

Function

DROP WORKLOAD GROUP deletes a workload group.

Precautions

Only a user with the DROP permission on the current database can perform this operation.

Syntax

DROP WORKLOAD GROUP [ IF EXISTS ] wg_name;

Parameter Description

• IF EXISTS

  Reports a notice instead of an error if the specified workload group does not exist.

• wg_name

  Specifies the name of the workload group to be deleted. The workload group must be unique in a database.

  Value range: an existing workload group name

Examples

See Examples in CREATE WORKLOAD GROUP.

Helpful Links

ALTER WORKLOAD GROUP and CREATE WORKLOAD GROUP