---
description: "sys.database_ledger_blocks (Transact-SQL)"
title: "sys.database_ledger_blocks (Transact-SQL) | Microsoft Docs"
ms.custom:
- event-tier1-build-2022
ms.date: "05/24/2022"
ms.prod: sql
ms.reviewer: ""
ms.technology: system-objects
ms.topic: "reference"
dev_langs: 
  - "TSQL"
author: VanMSFT
ms.author: vanto
monikerRange: "= azuresqldb-current||>= sql-server-ver16||>= sql-server-linux-ver16"
---
# sys.database_ledger_blocks (Transact-SQL)
[!INCLUDE [SQL Server 2022 Azure SQL Database](../../includes/applies-to-version/sqlserver2022-asdb.md)]

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

For more information on database ledger, see [Ledger](/azure/azure-sql/database/ledger-overview)

|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?](/sql/relational-databases/security/ledger/ledger-database-ledger)
- [Ledger Overview](/sql/relational-databases/security/ledger/ledger-overview)