Class SecuritySchema.SensitivityClassification

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.sensitivity_classifications (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics

Returns a row for each classified item in the database.

See sys.sensitivity_classifications.

[Table(Schema = "sys", Name = "sensitivity_classifications", IsView = true)]
public class SecuritySchema.SensitivityClassification

Inheritance

object

SecuritySchema.SensitivityClassification

Extension Methods

Map.DeepCopy<T>(T)

Properties

Class

Identifies the class of the item on which the classification exists. Will always have the value 1 (representing a column)

[Column("class")]
[NotNull]
public int Class { get; set; }

Property Value

int

ClassDesc

A description of the class of the item on which the classification exists. will always have the value OBJECT_OR_COLUMN

[Column("class_desc")]
[NotNull]
public string ClassDesc { get; set; }

Property Value

string

InformationType

The information type (human readable) assigned for the sensitivity classification

[Column("information_type")]
[Nullable]
public string? InformationType { get; set; }

Property Value

string

InformationTypeID

An ID associated with the information type, which can be used by an information protection system such as Azure Information Protection (AIP)

[Column("information_type_id")]
[Nullable]
public string? InformationTypeID { get; set; }

Property Value

string

Label

The label (human readable) assigned for the sensitivity classification

[Column("label")]
[Nullable]
public string? Label { get; set; }

Property Value

string

LabelID

An ID associated with the label, which can be used by an information protection system such as Azure Information Protection (AIP)

[Column("label_id")]
[Nullable]
public string? LabelID { get; set; }

Property Value

string

MajorID

Represents the ID of the table containing the classified column, corresponding with sys.all_objects.object_id

[Column("major_id")]
[NotNull]
public int MajorID { get; set; }

Property Value

int

MinorID

Represents the ID of the column on which the classification exists, corresponding with sys.all_columns.column_id

[Column("minor_id")]
[NotNull]
public int MinorID { get; set; }

Property Value

int

Rank

A numerical value of the rank:

0 for NONE
10 for LOW
20 for MEDIUM
30 for HIGH
40 for CRITICAL

[Column("rank")]
[Nullable]
public int? Rank { get; set; }

Property Value

int?

RankDesc

Textual representation of the rank:

NONE, LOW, MEDIUM, HIGH, CRITICAL

[Column("rank_desc")]
[Nullable]
public string? RankDesc { get; set; }

Property Value

string