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

• What is the database ledger?
• Ledger Overview