DataClassification

Get-DbaDbDataClassification

the dbatools team + Claude

Get-DbaDbDataClassification View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves data classification information for columns in SQL Server databases Description Retrieves data classification labels stored as extended properties on table columns. Data classification is used to tag sensitive data columns with information type and sensitivity labels, which helps with compliance, data governance, and security auditing.

Remove-DbaDbDataClassification

the dbatools team + Claude

Remove-DbaDbDataClassification View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes data classification labels from SQL Server table columns Description Removes all data classification metadata from table columns by dropping the four extended properties: sys_information_type_id sys_information_type_name sys_sensitivity_label_id sys_sensitivity_label_name Accepts piped input from Get-DbaDbDataClassification, making it easy to remove classifications from specific columns or bulk-remove classifications across databases.

Set-DbaDbDataClassification

the dbatools team + Claude

Set-DbaDbDataClassification View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Adds or updates data classification labels on SQL Server table columns Description Creates or updates data classification metadata on table columns by setting four extended properties: sys_information_type_id: GUID identifying the information type sys_information_type_name: Human-readable information type name sys_sensitivity_label_id: GUID identifying the sensitivity label sys_sensitivity_label_name: Human-readable sensitivity label name This command performs an upsert: if a classification property already exists on the column it will be