नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
Applies to: 
Databricks SQL Databricks Runtime 16.1 and above
Removes a tag on a catalog, schema, table, view, volume, or column.
To remove tags from Unity Catalog securable objects, you must own the object or have all of the following privileges:
APPLY TAGon the objectUSE SCHEMAon the object's parent schemaUSE CATALOGon the object's parent catalog
Syntax
UNSET TAG ON
{ CATALOG catalog_name |
COLUMN relation_name . column_name |
{ SCHEMA | DATABASE } schema_name |
TABLE relation_name |
VIEW relation_name |
VOLUME volume_name }
tag_key
Parameters
CATALOG catalog_name
The name of the catalog from which to remove the tag.
COLUMN relation_name . column_name
The qualified name of the column to tag.
relation_namemust identify a view or a table. Therelation_namemust not include a temporal specification or options specification.SCHEMA schema_name
The name of the schema from which to remove the tag.
TABLE relation_name
The name of the table, or view from which to remove the tag. The name must not include a temporal specification or options specification.
VIEW relation_name
The name of the view from which to remove the tag.
VOLUME volume_name
The name of the volume from which to remove the tag.
tag_key
An identifier. If the tag cannot be found an exception is raised.
Examples
> SET TAG ON CATALOG catalog `cost_center` = `hr`;
> UNSET TAG ON CATALOG catalog cost_center;
> SET TAG ON TABLE catalog.schema.table cost_center = hr;
> UNSET TAG ON TABLE catalog.schema.table cost_center;
> SET TAG ON COLUMN table.ssn pii;
> UNSET TAG ON COLUMN table.ssn pii;
> SELECT table_name, column_name FROM information_schema.column_tags
WHERE tag_name = 'pii' AND schema_name = 'default';
table_name column_name
---------- -----------
table ssn