sys.dm_cryptographic_provider_algorithms (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Returns the algorithms supported by an Extensible Key Management (EKM) provider.

Topic link icon Transact-SQL Syntax Conventions


sys.dm_cryptographic_provider_algorithms ( provider_id )  


Identification number of the EKM provider, with no default.

Tables Returned

Column name Data type Description
algorithm_id int Is the identification number of the algorithm.
algorithm_tag nvarchar(60) Is the identification tag of the algorithm.
key_type nvarchar(128) Shows the key type. Returns either ASYMMETRIC KEY or SYMMETRIC KEY.
key_length int Indicates the key length in bits.


The user must be a member of the public database role.


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

SELECT * FROM sys.dm_cryptographic_provider_algorithms(1234567);  

See Also

Extensible Key Management (EKM)
Security-Related Dynamic Management Views and Functions (Transact-SQL)