sys.dm_cryptographic_provider_properties (Transact-SQL)
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) |
Remarks
The sys.dm_cryptographic_provider_properties view is visible to the public.
See Also
Reference
Security Catalog Views (Transact-SQL)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
Security-Related Dynamic Management Views and Functions (Transact-SQL)