Syntax

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

Arguments

• workspace_ID, workspace_name: ID or name of the workspace to delete.

• group_ID, group_name: ID or name of the workspace group that contains the workspace.

Remarks

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

• The IN GROUP clause specifies the ID or name of the workspace group that contains the workspace to delete.

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

• All the databases attached to a workspace are detached when the workspace is deleted (terminated).

Example

The following command deletes a workspace named examplews in a workspace named s2wsg:

DROP WORKSPACE IF EXISTS 'examplews' IN GROUP 's2wsg';