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.

Change History

Updated content

Corrected the name of this view. It was mistakenly listed as sys.dm_provider_properties.

Corrected the data types of the columns, and added the friendly_name column.