sys.ledger_column_history (Transact-SQL)

Applies to: YesAzure 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

Column name Data type Description
object_id int The object ID of the ledger table.
column_id int The column ID of the column in a ledger table.
column_name sysname The name of the column in ledger table. If the operation has changed the column name, this column captures the new column name.
operation_type tinyint 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..
operation_type_desc nvarchar(60) Textual description of the value of operation_type.


Requires the VIEW LEDGER CONTENT permission.

See also