DROP WORKSPACE

Removes a workspace. The Control Plane cascades the removal across the workspace's grants and metadata.

Category: securityPrivilege: ManageWorkspacesDeltaForge extension

Syntax

DROP WORKSPACE [IF EXISTS] <name>

Description

## Overview DROP WORKSPACE removes a workspace from the catalog. ## Behavior - Without IF EXISTS, dropping a non-existent workspace raises an error. - Cascading removal at the Control Plane invalidates workspace-scoped grants and clears workspace metadata. The exact set of cascaded artefacts is determined by the Control Plane. - The drop does not delete data tables or external storage. Tables persisted under a workspace's storage root remain on disk. ## Access Control Requires the `ManageWorkspaces` privilege (ACCOUNTADMIN by default). ## Compatibility DeltaForge extension.

Parameters

Name	Type	Description
`name`		Specifies the workspace to drop.
`if_exists`		Skip silently when the workspace does not exist.

Examples

DROP WORKSPACE retired_team;

DROP WORKSPACE IF EXISTS retired_team;

Pitfalls

DROP WORKSPACE does not delete data on the workspace's storage root. Tables, scripts, and other artefacts persist on disk and must be cleaned up separately if reuse of the storage root is intended.