SQL Dialects Reference/Transactions

Transactions

This page includes comparison tables which can be big and complex.

While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.

SQL version	Feature	Standard	DB2	Firebird	Ingres	Linter	MSSQL	MySQL	Oracle	PostgreSQL	SQLite	Virtuoso
?	Start	?	Implicit	?	?	?	BEGIN TRAN[SACTION]	BEGIN [WORK] START [TRANSACTION]	Implicit	BEGIN [WORK|TRANSACTION] START TRANSACTION	BEGIN [TRANSACTION]	Implicit
?	Commit	COMMIT [WORK]	COMMIT [WORK]	?	[EXEC SQL] COMMIT [WORK]	?	COMMIT [WORK] COMMIT TRAN[SACTION]	COMMIT [WORK]	COMMIT [WORK]	COMMIT [WORK|TRANSACTION]	COMMIT [TRANSACTION] END [TRANSACTION]	COMMIT WORK
?	Rollback whole transaction	ROLLBACK [WORK]	ROLLBACK [WORK]	?	[EXEC SQL] ROLLBACK [WORK]	?	ROLLBACK [WORK] ROLLBACK TRAN[SACTION]	ROLLBACK [WORK]	ROLLBACK [WORK]	ROLLBACK [WORK|TRANSACTION]	ROLLBACK [TRANSACTION]	ROLLBACK WORK
?	Define a savepoint x, while inside a transaction	?	SAVEPOINT x ON ROLLBACK RETAIN CURSORS	?	SAVEPOINT x	?	SAVE TRAN[SACTION] x	SAVEPOINT x	SAVEPOINT x	SAVEPOINT x	SAVEPOINT x	N/A
?	Rollback to given savepoint x	?	ROLLBACK [WORK] TO SAVEPOINT x	?	[EXEC SQL] ROLLBACK [WORK] TO x	?	ROLLBACK TRAN[SACTION] x	ROLLBACK [WORK] TO [SAVEPOINT] x	ROLLBACK [WORK] TO [SAVEPOINT] x	ROLLBACK [WORK|TRANSACTION] TO [SAVEPOINT] x	ROLLBACK [TRANSACTION] TO [SAVEPOINT] x	N/A
?	Release (forget) savepoint x	?	RELEASE [TO] SAVEPOINT x	?	N/A	?	N/A	RELEASE SAVEPOINT x	N/A	RELEASE [SAVEPOINT] x	RELEASE [SAVEPOINT] x	N/A
?	Prepare transaction named id	?	?	?	?	?	?	?	?	PREPARE TRANSACTION id	N/A	?
?	Commit prepared transaction named id	?	?	?	?	?	?	?	?	COMMIT PREPARED id	N/A	?
?	Rollback prepared transaction named id	?	?	?	?	?	?	?	?	ROLLBACK PREPARED id	N/A	?

	Start	Commit	Rollback	Prepare	Execute prepared
Firebird	Implicit, SET TRANSACTION	COMMIT [TRANSACTION]	ROLLBACK [TRANSACTION]	?	?
Linter	Implicit	a COMMIT statement is executed any DDL statement is executed any statement is executed in AUTOCOMMIT mode	a ROLLBACK statement is executed a user process is terminated abnormally or disconnects without COMMIT/ROLLBACK	?	?