sys.database_ledger_blocks (Transact-SQL)

Applies to: YesAzure SQL Database

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

For more information on database ledger, see Azure SQL Database ledger

Column name Data type Description
block_id bigint A sequence number identifying the row in this view.
transaction_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