| description | DROP SENSITIVITY CLASSIFICATION (Transact-SQL) | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| title | DROP SENSITIVITY CLASSIFICATION (Transact-SQL) | Microsoft Docs | |||||||||
| ms.date | 03/25/2019 | |||||||||
| ms.reviewer | ||||||||||
| ms.prod | sql | |||||||||
| ms.technology | t-sql | |||||||||
| ms.topic | language-reference | |||||||||
| ms.custom | ||||||||||
| ms.author | giladm | |||||||||
| author | giladmit | |||||||||
| f1_keywords |
|
|||||||||
| dev_langs |
|
|||||||||
| helpviewer_keywords |
|
|||||||||
| monikerRange | >= sql-server-ver15 || = azuresqldb-current |
[!INCLUDE sql-asdb-asdbmi-asa]
Drops sensitivity classification metadata from one or more database columns.
DROP SENSITIVITY CLASSIFICATION FROM
<object_name> [, ...n ]
<object_name> ::=
{
[schema_name.]table_name.column_name
}
object_name ([schema_name.]table_name.column_name)
Is the name of the database column from which to remove the classification. Currently only column classification is supported. - schema_name (optional) - Is the name of the schema to which the classified column belongs to. - table_name - Is the name of the table to which the classified column belongs to. - column_name - Is the name of the column from which to drop the classification.
- Multiple object classifications can be dropped using a single 'DROP SENSITIVITY CLASSIFICATION' statement.
Requires ALTER ANY SENSITIVITY CLASSIFICATION permission. The ALTER ANY SENSITIVITY CLASSIFICATION is implied by the database permission ALTER, or by the server permission CONTROL SERVER.
The following example removes the classification from the column dbo.sales.price.
DROP SENSITIVITY CLASSIFICATION FROM
dbo.sales.priceThe following example removes the classification from the columns dbo.sales.price, dbo.sales.discount, and SalesLT.Customer.Phone.
DROP SENSITIVITY CLASSIFICATION FROM
dbo.sales.price, dbo.sales.discount, SalesLT.Customer.Phone ADD SENSITIVITY CLASSIFICATION (Transact-SQL)