ALTER DATASET … DROP VERSION¶
Drops a dataset version.
- See also:
Syntax¶
ALTER DATASET [ IF EXISTS ] <name> DROP VERSION <version_name>
Parameters¶
nameThe name of the dataset that you’re dropping.
DROP VERSION version_nameThe name of the dataset version that you’re dropping.
Access control requirements¶
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. |
The USAGE privilege on the parent database and schema are required to perform operations on any object in a 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.
Examples¶
The following example drops version v1 of the my_dataset dataset:
ALTER DATASET my_dataset
DROP VERSION 'v1';