sys.dm_cryptographic_provider_properties (Transact-SQL)
Applies to: 
SQL Server
Returns information about registered cryptographic providers.
| Column name | Data type | Description |
|---|---|---|
| provider_id | int | Identification number of the cryptographic provider. |
| guid | uniqueidentifier | Unique provider GUID. |
| provider_version | nvarchar(256) | Version of the provider in the format 'aa.bb.cccc.dd'. |
| sqlcrypt_version | nvarchar(256) | Major version of the SQL Server Cryptographic API in the format 'aa.bb.cccc.dd'. |
| friendly_name | nvarchar(2048) | Name supplied by the provider. |
| authentication_type | nvarchar(256) | WINDOWS, BASIC, or OTHER. |
| symmetric_key_support | tinyint | 0 (not supported) 1 (supported) |
| symmetric_key_export | tinyint | 0 (not supported) 1 (supported) |
| symmetric_key_import | tinyint | 0 (not supported) 1 (supported) |
| symmetric_key_persistance | tinyint | 0 (not supported) 1 (supported) |
| asymmetric_key_support | tinyint | 0 (not supported) 1 (supported) |
| asymmetric_key_export | tinyint | 0 (not supported) 1 (supported) |
| symmetric_key_import | tinyint | 0 (not supported) 1 (supported) |
| symmetric_key_persistance | tinyint | 0 (not supported) 1 (supported) |
Permissions
The sys.dm_cryptographic_provider_properties view is visible to the public.
See Also
Security Catalog Views (Transact-SQL)
Encryption Hierarchy
Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
Security-Related Dynamic Management Views and Functions (Transact-SQL)