SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

sys.dm_cryptographic_provider_algorithms (Transact-SQL)

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

Topic link iconTransact-SQL Syntax Conventions

Copy 
sys.dm_cryptographic_provider_algorithms( provider_id )
provider_id

Identification number of the EKM provider, with no default.

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.

Copy 
SELECT * FROM sys.dm_cryptographic_provider_algorithms(1234567);
GO

Updated content

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.