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)