sys.dm_cryptographic_provider_algorithms( provider_id )
Identification number of the EKM provider, with no default.
Is the identification number of the algorithm.
Is the identification tag of the algorithm.
Shows the key type. Returns either ASYMMETRIC KEY or SYMMETRIC KEY.
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);
Corrected the name of this view. It was mistakenly listed as sys.dm_provider_algorithms.