sys.cryptographic_providers (Transact-SQL)

Applies to: 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)