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. |
Requires the VIEW LEDGER CONTENT permission.