Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
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 |
Permissions
The sys.cryptographic_providers view is visible to the public.
See Also
Security Catalog Views (Transact-SQL)
Encryption Hierarchy
Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)