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.