sys-cryptographic-providers-transact-sql.md

title	ms.custom	ms.date	ms.prod	ms.prod_service	ms.reviewer	ms.technology	ms.topic	f1_keywords	dev_langs	helpviewer_keywords	ms.assetid	author	ms.author	monikerRange
sys.cryptographic_providers (Transact-SQL) | Microsoft Docs		06/10/2016	sql	database-engine, sql-database		system-objects	language-reference	cryptographic_providers sys.cryptographic_providers sys.cryptographic_providers_TSQL cryptographic_providers_TSQL	TSQL	sys.cryptographic_providers catalog view	9da0da95-792e-48b4-9f60-47f0729c279c	VanMSFT	vanto	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

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)