Table of Contents

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
SecuritySchema.ColumnMasterKey
Inherited Members
Extension Methods

Properties

AllowEnclaveComputations

allow_enclave_computations NOT NULL bit

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

column_master_key_id NOT NULL int

ID of the column master key. 
[Column("column_master_key_id")]
[NotNull]
public int ColumnMasteRKeyID { get; set; }

Property Value

int

CreateDate

create_date NOT NULL datetime

Date the column master key was created. 
[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

KeyPath

key_path NULL nvarchar(4000)

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

key_store_provider_name NULL sysname

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

modify_date NOT NULL datetime

Date the column master key was last modified. 
[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

name NOT NULL sysname

The name of the CMK. 
[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Signature

signature NULL varbinary(max)

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[]