sys.cryptographic_providers (Transact-SQL)

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

Reference

Security Catalog Views (Transact-SQL)

CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)

Concepts

Encryption Hierarchy

Extensible Key Management (EKM)