UNSET TAG
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