sys.dm_cryptographic_provider_algorithms (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 the algorithms supported by an Extensible Key Management (EKM) provider.

Topic link icon Transact-SQL Syntax Conventions

  
sys.dm_cryptographic_provider_algorithms ( provider_id )  

provider_id
Identification number of the EKM provider, with no default.

Column nameData typeDescription
algorithm_idintIs the identification number of the algorithm.
algorithm_tagnvarchar(60)Is the identification tag of the algorithm.
key_typenvarchar(128)Shows the key type. Returns either ASYMMETRIC KEY or SYMMETRIC KEY.
key_lengthintIndicates 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);  
GO  

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

Community Additions

ADD
Show: