sys.cryptographic_providers (Transact-SQL)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database

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)