ALTER DATASET … DROP VERSION¶

Drops a dataset version.

Syntax¶

ALTER DATASET [ IF EXISTS ] <name> DROP VERSION <version_name>

Copy

name: The name of the dataset that you’re dropping.
DROP VERSION version_name: The name of the dataset version that you’re dropping.

A role used to execute this operation must have the following privileges at a minimum:

Privilege	Object	Notes
OWNERSHIP	Dataset	Provides the privilege to both read and modify the dataset.

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

The following example drops version v1 of the my_dataset dataset:

ALTER DATASET my_dataset
DROP VERSION 'v1';

Copy