Table of Contents

Class SecuritySchema.LedgerTableHistory

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

sys.ledger_table_history (Transact-SQL)

Applies to: √ Azure SQL Database

Captures the cryptographically protected history of operations on ledger tables: creating ledger tables, renaming ledger tables or ledger views, and dropping ledger tables.
For more information on database ledger, see Azure SQL Database ledger


See sys.ledger_table_history.

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

Properties

LedgerViewName

The name of the ledger view for the ledger table. If the operation has changed the view name, this column captures the new view name.

[Column("ledger_view_name")]
[NotNull]
public string LedgerViewName { get; set; }

Property Value

string

LedgerViewSchemaName

The name of the schema containing the ledger view for the ledger table. If the operation has changed the schema name, this column captures the new schema name.

[Column("ledger_view_schema_name")]
[NotNull]
public string LedgerViewSchemaName { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

The object ID of the ledger table.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

OperationType

The numeric value indicating the type of the operation

0 = CREATE – creating a ledger table.
1 = DROP – dropping a ledger table.

[Column("operation_type")]
[NotNull]
public byte OperationType { get; set; }

Property Value

byte

OperationTypeDesc

Textual description of the value of operation_type.

[Column("operation_type_desc")]
[NotNull]
public string OperationTypeDesc { get; set; }

Property Value

string

SchemaName

The name of the schema containing the ledger table. If the operation has changed the schema name, this column captures the new schema name.

[Column("schema_name")]
[NotNull]
public string SchemaName { get; set; }

Property Value

string

SequenceNumber

The sequence number of the operation within the transaction.

[Column("sequence_number")]
[NotNull]
public long SequenceNumber { get; set; }

Property Value

long

TableName

The name of the ledger table. If the operation has changed the table name, this column captures the new table name.

[Column("table_name")]
[NotNull]
public string TableName { get; set; }

Property Value

string

TransactionID

The transaction of the ID that included the operation on the ledger table. It identifies a row in sys.database_ledger_transactions.

[Column("transaction_id")]
[NotNull]
public long TransactionID { get; set; }

Property Value

long