1ROLLBACK(7) SQL Commands ROLLBACK(7)
2
3
4
6 ROLLBACK - abort the current transaction
7
8
10 ROLLBACK [ WORK | TRANSACTION ]
11
12
14 ROLLBACK rolls back the current transaction and causes all the updates
15 made by the transaction to be discarded.
16
18 WORK
19
20 TRANSACTION
21 Optional key words. They have no effect.
22
24 Use COMMIT [commit(7)] to successfully terminate a transaction.
25
26 Issuing ROLLBACK when not inside a transaction does no harm, but it
27 will provoke a warning message.
28
30 To abort all changes:
31
32 ROLLBACK;
33
34
36 The SQL standard only specifies the two forms ROLLBACK and ROLLBACK
37 WORK. Otherwise, this command is fully conforming.
38
40 BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK TO SAVEPOINT [roll‐
41 back_to_savepoint(7)]
42
43
44
45SQL - Language Statements 2014-02-17 ROLLBACK(7)