SQL Commit / Rollback
When a connection is setup with the auto-commit mode set to off, the SQL Commit and Rollback options become available.
Use the commit option to commit a transaction or statement of work to the database. Use the rollback option to rollback any work since the last commit.
Please note that some databases do not support transactions, such as older versions of MySQL. In these cases, the commit and rollback options become meaningless. Also, some databases handle transactions differently than others. For example, PostgreSQL handles transactions differently than the other major databases such as Oracle or SQL Server. RazorSQL attempts to handle this by issuing SavePoints when using PostgreSQL in auto-commit off mode so that transactions do not get into an invalid state.
