sys.database_ledger_blocks (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure SQL Managed Instance

Captures the cryptographically chained blocks, each of which represents a block of transactions against ledger tables.

For more information on database ledger, see Ledger

Column name Data type Description
block_id bigint A sequence number identifying the row in this view.
transactions_root_hash binary(32) The hash of the root of the Merkle tree, formed by transactions stored in the block.
block_size bigint The number of transactions in the block.
previous_block_hash binary(32) A SHA-256 hash of the previous row in the view.

Permissions

Requires the VIEW LEDGER CONTENT permission.

See also