sys.dm_cryptographic_provider_algorithms (Transact-SQL)

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

Transact-SQL Syntax Conventions

Syntax

sys.dm_cryptographic_provider_algorithms( provider_id )

Arguments

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

Permissions

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

Examples

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

See Also

Reference

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

Concepts

Understanding Extensible Key Management (EKM)

Change History

Updated content
Corrected the name of this view. It was mistakenly listed as sys.dm_provider_algorithms.