Transaction
This page provides a comprehensive overview of Transaction operations in Databend, organized by functionality for easy reference.
Transaction Control
| Command | Description | 
|---|---|
| BEGIN | Starts a new transaction | 
| COMMIT | Commits the current transaction and makes all changes permanent | 
| ROLLBACK | Aborts the current transaction and discards all changes | 
Transaction Information
| Command | Description | 
|---|---|
| SHOW LOCKS | Displays 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.