sys.cryptographic_providers (Transact-SQL)


Updated: June 10, 2016

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 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 ''.
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)

Community Additions