sys.cryptographic_providers (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. 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)