Class SecuritySchema.CryptographicProvider

sys.cryptographic_providers (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database

Returns one row for each registered cryptographic provider.

[Table(Schema = "sys", Name = "cryptographic_providers", IsView = true)]
public class SecuritySchema.CryptographicProvider

Properties

Path to DLL that implements the Extensible Key Management (EKM) Application Program Interface (API).

[Column("dll_path")]
[Nullable]
public string? DllPath { get; set; }

Unique provider GUID.

[Column("guid")]
[Nullable]
public Guid? Guid { get; set; }

Whether the provider is enabled on the server or not.

0 = not enabled (default)

1 = enabled

[Column("is_enabled")]
[NotNull]
public bool IsEnabled { get; set; }

Name of the cryptographic provider.

[Column("name")]
[NotNull]
public string Name { get; set; }

Identification number of the cryptographic provider.

[Column("provider_id")]
[NotNull]
public int ProviderID { get; set; }

Version of the provider in the format 'aa.bb.cccc.dd'.

[Column("version")]
[Nullable]
public string? Version { get; set; }