sys.dm_cryptographic_provider_properties (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

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)