sys.dm_cryptographic_provider_keys (Transact-SQL)

Applies to: SQL Server

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

Transact-SQL syntax conventions


This dynamic management view is currently not supported by the SQL Server EKM Connector. The SQL Server product team is aware of this issue and will address this in the future.


dm_cryptographic_provider_keys ( provider_id )  


Identification number of the EKM provider, with no default.

Tables Returned

Column name Data type Description
key_id int Identification number of the key on the provider.
key_name nvarchar(512) Name of the key on the provider.
key_thumbprint varbinary(32) Thumbprint from the provider of the key.
algorithm_id int Identification number of the algorithm on the provider.
algorithm_tag int Tag of the algorithm on the provider.
key_type nchar(256) Type of key on the provider.
key_length int Length 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);  

See Also

Extensible Key Management (EKM)