title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

f1_keywords

helpviewer_keywords

dev_langs

sys.dm_cryptographic_provider_properties (Transact-SQL)

rwestMSFT

randolphwest

06/10/2016

sql

system-objects

reference

dm_cryptographic_provider_properties_TSQL

sys.dm_cryptographic_provider_properties

sys.dm_cryptographic_provider_properties_TSQL

dm_cryptographic_provider_properties

sys.dm_cryptographic_provider_properties dynamic management view

TSQL

sys.dm_cryptographic_provider_properties (Transact-SQL)

[!INCLUDE 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 [!INCLUDEssNoVersion] 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.