| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
sys.database_ledger_blocks (Transact-SQL) |
sys.database_ledger_blocks (Transact-SQL) |
VanMSFT |
vanto |
05/23/2023 |
sql |
system-objects |
reference |
|
=azuresqldb-current||>=sql-server-ver16||>=sql-server-linux-ver16 |
[!INCLUDE SQL Server 2022 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.