DROP SENSITIVITY CLASSIFICATION (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Drops sensitivity classification metadata from one or more database columns.
Syntax
DROP SENSITIVITY CLASSIFICATION FROM
<object_name> [, ...n ]
<object_name> ::=
{
[schema_name.]table_name.column_name
}
Arguments
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.
Remarks
- Multiple object classifications can be dropped using a single 'DROP SENSITIVITY CLASSIFICATION' statement.
Permissions
Requires ALTER ANY SENSITIVITY CLASSIFICATION permission. The ALTER ANY SENSITIVITY CLASSIFICATION is implied by the database permission CONTROL, or by the server permission CONTROL SERVER.
Examples
A. Dropping classification from a single column
The following example removes the classification from the column dbo.sales.price
.
DROP SENSITIVITY CLASSIFICATION FROM
dbo.sales.price
B. Dropping classification from multiple columns
The 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
See Also
ADD SENSITIVITY CLASSIFICATION (Transact-SQL)
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre