sys.sensitivity_classifications

Returns one row for every classified column in the current virtual database. Columns are classified with ADD SENSITIVITY CLASSIFICATION. The view takes its name and shape from SQL Server’s sys.sensitivity_classifications catalog view.

Only columns can be classified, so class is always 1 (OBJECT_OR_COLUMN).

Column name	Data type	Description
class	int	Class of the classified item. Always 1 (a column).
class_desc	varchar(16)	Description of the class. Always OBJECT_OR_COLUMN.
major_id	int	Object id of the table the classified column belongs to.
minor_id	int	Column id of the classified column (matches sys.columns.column_id).
label	sysname	The sensitivity label, or NULL when only an information type was set.
label_id	sysname	The label identifier, or NULL.
information_type	sysname	The information type, or NULL when only a label was set.
information_type_id	sysname	The information type identifier, or NULL.
rank	int	The numeric sensitivity rank (0 NONE, 10 LOW, 20 MEDIUM, 30 HIGH, 40 CRITICAL), or NULL when no rank was set.
rank_desc	varchar(8)	The rank name (NONE, LOW, MEDIUM, HIGH, CRITICAL), or NULL.

Permissions

Requires the VIEW SERVER STATE permission.

Example

SELECT major_id, minor_id, label, information_type, rank_desc
FROM sys.sensitivity_classifications;

See Also

• SENSITIVITY CLASSIFICATION

• System views