sys.column_master_keys (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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).

Column name Data type Description
name sysname The name of the CMK.
column_master_key_id int ID of the column master key.
create_date datetime Date the column master key was created.
modify_date datetime Date the column master key was last modified.
key_store_provider_name 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.
key_path 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.

Permissions

Requires the VIEW ANY COLUMN MASTER KEY permission.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

CREATE COLUMN MASTER KEY (Transact-SQL)
Security Catalog Views (Transact-SQL)
Always Encrypted (Database Engine)
sys.column_encryption_key_values (Transact-SQL)