ALTER DATASET ...DROP VERSION¶
丢弃数据集版本。
语法¶
ALTER DATASET [ IF EXISTS ] <name> DROP VERSION <version_name>
参数¶
name
您要删除的数据集的名称。
DROP VERSION version_name
您要删除的数据集版本的名称。
访问控制要求¶
A role used to execute this operation must have the following privileges at a minimum:
权限 |
对象 |
备注 |
---|---|---|
OWNERSHIP |
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 创建自定义角色.
For general information about roles and privilege grants for performing SQL actions on securable objects, see 访问控制概述.
示例¶
以下示例删除了 my_dataset
数据集的版本 v1
:
ALTER DATASET my_dataset
DROP VERSION 'v1';