sys-dm-cryptographic-provider-algorithms-transact-sql.md

title	sys.dm_cryptographic_provider_algorithms (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	dm_cryptographic_provider_algorithms_TSQL sys.dm_cryptographic_provider_algorithms sys.dm_cryptographic_provider_algorithms_TSQL dm_cryptographic_provider_algorithms
dev_langs	TSQL
helpviewer_keywords	sys.dm_cryptographic_provider_algorithms dynamic management function
ms.assetid	8bcccb37-5cfb-4e1e-a0bb-7ff4c279fe8e
author	stevestein
ms.author	sstein

sys.dm_cryptographic_provider_algorithms (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

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