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 SQL:2011	DB2	Firebird	Ingres	Linter	MSSQL	MySQL Vers. 5.x	MonetDB	Oracle Vers. 11.x	PostgreSQL	SQLite	Virtuoso
?	Start	START TRANSACTION [transaction characteristics]	Implicit	SET TRANSACTION	?	?	BEGIN TRAN[SACTION]	BEGIN [WORK] START [TRANSACTION]	START TRANSACTION BEGIN TRANSACTION	Implicit	BEGIN [WORK\|TRANSACTION] START TRANSACTION	BEGIN [TRANSACTION]	Implicit
?	Commit	COMMIT [WORK]	COMMIT [WORK]	COMMIT [WORK]	[EXEC SQL] COMMIT [WORK]	?	COMMIT [WORK] COMMIT TRAN[SACTION] [transaction_name]	COMMIT [WORK]	COMMIT [WORK] [AND [NO] CHAIN]	COMMIT [WORK]	COMMIT [WORK\|TRANSACTION]	COMMIT [TRANSACTION] END [TRANSACTION]	COMMIT WORK
?	Rollback whole transaction	ROLLBACK [WORK]	ROLLBACK [WORK]	ROLLBACK [WORK]	[EXEC SQL] ROLLBACK [WORK]	?	ROLLBACK [WORK] ROLLBACK TRAN[SACTION]	ROLLBACK [WORK]	ROLLBACK [WORK] [AND [NO] CHAIN]	ROLLBACK [WORK]	ROLLBACK [WORK\|TRANSACTION]	ROLLBACK [TRANSACTION]	ROLLBACK WORK
?	Define a savepoint x, while inside a transaction	SAVEPOINT x	SAVEPOINT x ON ROLLBACK RETAIN CURSORS	SAVEPOINT x	SAVEPOINT x	?	SAVE TRAN[SACTION] x	SAVEPOINT x	SAVEPOINT x	SAVEPOINT x	SAVEPOINT x	SAVEPOINT x	N/A
?	Rollback to given savepoint x	ROLLBACK [WORK] TO SAVEPOINT x	ROLLBACK [WORK] TO SAVEPOINT x	ROLLBACK [WORK] TO [SAVEPOINT] x	[EXEC SQL] ROLLBACK [WORK] TO x	?	ROLLBACK TRAN[SACTION] x	ROLLBACK [WORK] TO [SAVEPOINT] x	ROLLBACK [WORK] [AND [NO] CHAIN] 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 SAVEPOINT x	RELEASE [TO] SAVEPOINT x	RELEASE SAVEPOINT x	N/A	?	N/A	RELEASE SAVEPOINT x	RELEASE SAVEPOINT x	N/A	RELEASE [SAVEPOINT] x	RELEASE [SAVEPOINT] x	N/A
?	Prepare transaction named id for two-phase commit	?	?	N/A	?	?	?	?	N/A	?	PREPARE TRANSACTION id	N/A	?
?	Commit prepared transaction named id	?	?	N/A	?	?	?	?	N/A	?	COMMIT PREPARED id	N/A	?
?	Rollback prepared transaction named id	?	?	N/A	?	?	?	?	N/A	?	ROLLBACK PREPARED id	N/A	?

	Start	Commit	Rollback	Prepare	Execute prepared
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`	?	?