Table of Contents

Class SecuritySchema.LedgerColumnHistory

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

sys.ledger_column_history (Transact-SQL)

Applies to: √ Azure SQL Database

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


See sys.ledger_column_history.

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

Properties

ColumnID

The column ID of the column in a ledger table.

[Column("column_id")]
[NotNull]
public int ColumnID { get; set; }

Property Value

int

ColumnName

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

[Column("column_name")]
[NotNull]
public string ColumnName { 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 column as part of creating the table containing the column using CREATE TABLE.
1 = ADD – adding a column in a ledger table, using ALTER TABLE/ADD COLUMN..

[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