Table of Contents

Class SecuritySchema.Certificate

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.certificates (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Returns a row for each certificate in the database.


See sys.certificates.

[Table(Schema = "sys", Name = "certificates", IsView = true)]
public class SecuritySchema.Certificate
Inheritance
SecuritySchema.Certificate
Extension Methods

Properties

AttestedBy

System use only.

[Column("attested_by")]
[Nullable]
public string? AttestedBy { get; set; }

Property Value

string

CertSerialNumber

Serial number of certificate.

[Column("cert_serial_number")]
[Nullable]
public string? CertSerialNumber { get; set; }

Property Value

string

CertificateID

ID of the certificate. Is unique within the database.

[Column("certificate_id")]
[NotNull]
public int CertificateID { get; set; }

Property Value

int

ExpiryDate

When certificate expires.

[Column("expiry_date")]
[Nullable]
public DateTime? ExpiryDate { get; set; }

Property Value

DateTime?

IsActiveForBeginDialog

If 1, this certificate is used to initiate encrypted service dialogs.

[Column("is_active_for_begin_dialog")]
[Nullable]
public bool? IsActiveForBeginDialog { get; set; }

Property Value

bool?

IssuerName

Name of certificate issuer.

[Column("issuer_name")]
[Nullable]
public string? IssuerName { get; set; }

Property Value

string

Name

Name of the certificate. Is unique within the database.

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

Property Value

string

PrincipalID

ID of the database principal that owns this certificate.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

PvtKeyEncryptionType

How the private key is encrypted.

NA = There is no private key for the certificate

MK = Private key is encrypted by the master key

PW = Private key is encrypted by a user-defined password

SK = Private key is encrypted by the service master key.

[Column("pvt_key_encryption_type")]
[NotNull]
public string PvtKeyEncryptionType { get; set; }

Property Value

string

PvtKeyEncryptionTypeDesc

Description of how the private key is encrypted.

NO_PRIVATE_KEY

ENCRYPTED_BY_MASTER_KEY

ENCRYPTED_BY_PASSWORD

ENCRYPTED_BY_SERVICE_MASTER_KEY

[Column("pvt_key_encryption_type_desc")]
[Nullable]
public string? PvtKeyEncryptionTypeDesc { get; set; }

Property Value

string

PvtKeyLastBackupDate

The date and time the certificate's private key was last exported.

[Column("pvt_key_last_backup_date")]
[Nullable]
public DateTime? PvtKeyLastBackupDate { get; set; }

Property Value

DateTime?

SID

Login SID for this certificate.

[Column("sid")]
[Nullable]
public byte[]? SID { get; set; }

Property Value

byte[]

StartDate

When certificate becomes valid.

[Column("start_date")]
[Nullable]
public DateTime? StartDate { get; set; }

Property Value

DateTime?

StringSID

String representation of the login SID for this certificate

[Column("string_sid")]
[Nullable]
public string? StringSID { get; set; }

Property Value

string

Subject

Subject of this certificate.

[Column("subject")]
[Nullable]
public string? Subject { get; set; }

Property Value

string

Thumbprint

SHA-1 hash of the certificate. The SHA-1 hash is globally unique.

[Column("thumbprint")]
[NotNull]
public byte[] Thumbprint { get; set; }

Property Value

byte[]