DROP WORKSPACE
On this page
The DROP WORKSPACE command deletes the specified cluster.
Syntax
DROP WORKSPACE [ IF EXISTS ]
{ ID '<cluster_ID>' | '<cluster_name>' }
[ IN GROUP { ID '<group_ID>' | '<group_name>' } ]
[ WAIT ON TERMINATED ]Arguments
-
cluster_,ID cluster_: ID or name of the cluster to delete.name -
group_,ID group_: ID or name of the cluster group that contains the cluster.name
Remarks
-
Specify the
IF EXISTSclause to attempt the delete operation only if a cluster with the specified ID or name exists. -
The
IN GROUPclause specifies the ID or name of the cluster group that contains the cluster to delete. -
Specify the
WAIT ON TERMINATEDclause to pause query execution until the cluster is in theTERMINATEDstate. -
All the databases attached to a cluster are detached when the cluster is deleted (terminated).
Example
The following command deletes a cluster named examples in a cluster named s2-group:
DROP WORKSPACE IF EXISTS 'examples' IN GROUP 's2-group';
Last modified: