Skip to content

Latest commit

 

History

History
62 lines (48 loc) · 2.25 KB

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

File metadata and controls

62 lines (48 loc) · 2.25 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.dm_cryptographic_provider_algorithms (Transact-SQL)
sys.dm_cryptographic_provider_algorithms (Transact-SQL)
rwestMSFT
randolphwest
06/10/2016
sql
system-objects
reference
dm_cryptographic_provider_algorithms_TSQL
sys.dm_cryptographic_provider_algorithms
sys.dm_cryptographic_provider_algorithms_TSQL
dm_cryptographic_provider_algorithms
sys.dm_cryptographic_provider_algorithms dynamic management function
TSQL

sys.dm_cryptographic_provider_algorithms (Transact-SQL)

[!INCLUDE SQL Server]

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions (Transact-SQL)

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)