sys-cryptographic-providers-transact-sql.md

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

sys.cryptographic_providers (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

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

Permissions

The sys.cryptographic_providers view is visible to the public.

See Also

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