Class SecuritySchema.ColumnMasterKey

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.column_master_keys (Transact-SQL)

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

Returns a row for each database master key added by using the CREATE MASTER KEY statement. Each row represents a single column master key (CMK).

See sys.column_master_keys.

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

Inheritance

object

SecuritySchema.ColumnMasterKey

Extension Methods

Map.DeepCopy<T>(T)

Properties

AllowEnclaveComputations

Indicates if the column master key is enclave-enabled, (if column encryption keys, encrypted with this master key, can be used for computations inside server-side secure enclaves). For more information, see Always Encrypted with secure enclaves.

[Column("allow_enclave_computations")]
[NotNull]
public bool AllowEnclaveComputations { get; set; }

Property Value

bool

ColumnMasteRKeyID

ID of the column master key.

[Column("column_master_key_id")]
[NotNull]
public int ColumnMasteRKeyID { get; set; }

Property Value

int

CreateDate

Date the column master key was created.

[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

KeyPath

A column master key store-specific path of the key. The format of the path depends on the column master key store type. Example:

'CurrentUser/Personal/'<thumbprint>

For a custom column master key store, the developer is responsible for defining what a key path is for the custom column master key store.

[Column("key_path")]
[Nullable]
public string? KeyPath { get; set; }

Property Value

string

KeyStoreProviderName

Name of the provider for the column master key store that contains the CMK. Allowed values are:

MSSQL_CERTIFICATE_STORE - If the column master key store is a Certificate Store.

A user-defined value, if the column master key store is of a custom type.

[Column("key_store_provider_name")]
[Nullable]
public string? KeyStoreProviderName { get; set; }

Property Value

string

ModifyDate

Date the column master key was last modified.

[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

The name of the CMK.

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

Property Value

string

Signature

A digital signature of key_path and allow_enclave_computations, produced using the column master key, referenced by key_path.

[Column("signature")]
[Nullable]
public byte[]? Signature { get; set; }

Property Value

byte[]