Skip to main content

Transaction

This page provides a comprehensive overview of Transaction operations in Databend, organized by functionality for easy reference.

Transaction Control

CommandDescription
BEGINStarts a new transaction
COMMITCommits the current transaction and makes all changes permanent
ROLLBACKAborts the current transaction and discards all changes

Transaction Information

CommandDescription
SHOW LOCKSDisplays information about active locks in the system
note

Transactions in Databend ensure data consistency by grouping SQL operations into atomic units that either completely succeed or completely fail, maintaining database integrity.

Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today