Table of Contents

Class ObjectSchema.MaskedColumn

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.masked_columns (Transact-SQL)

Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance

Use the sys.masked_columns view to query for table-columns that have a dynamic data masking function applied to them. This view inherits from the sys.columns view. It returns all columns in the sys.columns view, plus the is_masked and masking_function columns, indicating if the column is masked, and if so, what masking function is defined. This view only shows the columns on which there is a masking function applied.


See sys.masked_columns.

[Table(Schema = "sys", Name = "masked_columns", IsView = true)]
public class ObjectSchema.MaskedColumn
Inheritance
ObjectSchema.MaskedColumn
Extension Methods

Properties

ColumnID

ID of the column. Is unique within the object.

Column IDs might not be sequential.

[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

Property Value

int

GeneratedAlwaysType

Applies to: SQL Server 2016 (13.x) and later, SQL Database. 7, 8, 9, 10 only applies to SQL Database.

Identifies when the column value is generated (will always be 0 for columns in system tables):

0 = NOT_APPLICABLE
1 = AS_ROW_START
2 = AS_ROW_END
7 = AS_TRANSACTION_ID_START
8 = AS_TRANSACTION_ID_END
9 = AS_SEQUENCE_NUMBER_START
10 = AS_SEQUENCE_NUMBER_END

For more information, see Temporal Tables (Relational databases).

[Column("generated_always_type")]
[Nullable]
public byte? GeneratedAlwaysType { get; set; }

Property Value

byte?

IsMasked

Indicates if the column is masked. 1 indicates masked.

[Column("is_masked")]
[Nullable]
public bool? IsMasked { get; set; }

Property Value

bool?

MaskingFunction

The masking function for the column.

[Column("masking_function")]
[Nullable]
public string? MaskingFunction { get; set; }

Property Value

string

Name

Name of the column. Is unique within the object.

[Column("name")]
[Nullable]
public string? Name { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

ID of the object to which this column belongs.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

SysMaskedColumns

See sys.columns (Transact-SQL) for more column definitions.

[Column("sys.masked_columns")]
[NotNull]
public object SysMaskedColumns { get; set; }

Property Value

object