sys-cryptographic-providers-transact-sql.md

title	sys.cryptographic_providers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	cryptographic_providers sys.cryptographic_providers sys.cryptographic_providers_TSQL cryptographic_providers_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.cryptographic_providers catalog view
ms.assetid	9da0da95-792e-48b4-9f60-47f0729c279c
caps.latest.revision	13
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.cryptographic_providers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

Returns one row for each registered cryptographic provider.

Column name	Data type	Description
provider_id	int	Identification number of the cryptographic provider.
name	sysname	Name of the cryptographic provider.
guid	uniqueidentifier	Unique provider GUID.
version	nvarchar(50)	Version of the provider in the format 'aa.bb.cccc.dd'.
dll_path	nvarchar(512)	Path to DLL that implements the Extensible Key Management (EKM) Application Program Interface (API).
is_enabled	bit	Whether the provider is enabled on the server or not. 0 = not enabled (default) 1 = enabled

Remarks

The sys.cryptographic_providers view is visible to the public.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Security Catalog Views (Transact-SQL)
Encryption Hierarchy
Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)