TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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