sys.cryptographic_providers (Transact-SQL)

sys.cryptographic_providers (Transact-SQL)

 

Applies To: SQL Server

Returns one row for each registered cryptographic provider.

Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12 (Preview in some regions).
Column nameData typeDescription
provider_idintIdentification number of the cryptographic provider.
namesysnameName of the cryptographic provider.
guiduniqueidentifierUnique provider GUID.
versionnvarchar(50)Version of the provider in the format 'aa.bb.cccc.dd'.
dll_pathnvarchar(512)Path to DLL that implements the Extensible Key Management (EKM) Application Program Interface (API).
is_enabledbitWhether the provider is enabled on the server or not.

0 = not enabled (default)

1 = enabled

The sys.cryptographic_providers view is visible to the public.

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.

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

Community Additions

ADD
Show:
© 2016 Microsoft