sys.dm_cryptographic_provider_keys (Transact-SQL)


Updated: June 10, 2016

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

Returns information about the keys provided by a Extensible Key Management (EKM) provider.

Topic link icon Transact-SQL Syntax Conventions

dm_cryptographic_provider_keys ( provider_id )  

Identification number of the EKM provider, with no default.

Column nameData typeDescription
key_idintIdentification number of the key on the provider.
key_namenvarchar(512)Name of the key on the provider.
key_thumbprintvarbinary(32)Thumbprint from the provider of the key.
algorithm_idintIdentification number of the algorithm on the provider.
algorithm_tagintTag of the algorithm on the provider.
key_typenchar(256)Type of key on the provider.
key_lengthintLength of the key on the provider.

When this view is queried it will authenticate the user context with the provider and enumerate all keys visible to the user.

If the user cannot authenticate with the EKM provider, no key information will be returned.

The following example shows the key properties for a provider with the identification number of 1234567.

SELECT * FROM sys.dm_cryptographic_provider_keys(1234567);  

Extensible Key Management (EKM)

Community Additions