Transactions

Transactions are a database feature that allow you to perform a set of table operations as a single unit. Transactions are useful when you have sets of table operations that must all be completed for the integrity of the data to be maintained. Partial completion of the operations would leave the database in an inconsistent state.

For example, a transaction would be useful when transferring a balance from one account to another. This operation requires two actions: decreasing the balance of one account and increasing the balance of the other. Both operations must be completed to maintain the integrity of the data. If either operation can’t be completed, the desired behavior is to “roll back” the transaction, as if it had never been attempted.

Information about transactions is divided into the following sections:

 


Documentation Feedback