Table of Contents

Class SecuritySchema.OpenKey

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

sys.openkeys (Transact-SQL)

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

This catalog view returns information about encryption keys that are open in the current session.


See sys.openkeys.

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

Properties

DatabaseID

ID of the database that contains the key.

[Column("database_id")]
[Nullable]
public int? DatabaseID { get; set; }

Property Value

int?

DatabaseName

Name of the database that contains the key.

[Column("database_name")]
[Nullable]
public string? DatabaseName { get; set; }

Property Value

string

KeyGuid

GUID of the key. Unique within the database.

[Column("key_guid")]
[Nullable]
public byte[]? KeyGuid { get; set; }

Property Value

byte[]

KeyID

ID of the key. The ID is unique within the database.

[Column("key_id")]
[Nullable]
public int? KeyID { get; set; }

Property Value

int?

KeyName

Name of the key. Unique within the database.

[Column("key_name")]
[Nullable]
public string? KeyName { get; set; }

Property Value

string

OpenedDate

Date and time when the key was opened.

[Column("opened_date")]
[Nullable]
public DateTime? OpenedDate { get; set; }

Property Value

DateTime?

Status

1 if the key is valid in metadata. 0 if the key is not found in metadata.

[Column("status")]
[Nullable]
public int? Status { get; set; }

Property Value

int?