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.