Syntax

DROP WORKSPACE GROUP [ IF EXISTS ]
    { ID '<group_ID>' | '<group_name>' } 
    [ WAIT ON TERMINATED ]
    [ FORCE ]

Argument

• group_ID, group_name: ID or name of the workspace group to delete.

Remarks

• Specify the IF EXISTS clause to attempt the delete operation only if a workspace group with the specified ID or name exists.

• Specify the WAIT ON TERMINATED clause to pause query execution until the workspace group is in the TERMINATED state.

• If the FORCE clause is specified, the workspace group is deleted (terminated) even if it contains workspaces.

Example

The following command deletes a workspace group named s2wsg:

DROP WORKSPACE GROUP 's2wsg' FORCE;