Chapter 9 SQL Statements
597
ROLLBACK statement
Use this statement to end a transaction and undo any changes made since the
last COMMIT or ROLLBACK.
ROLLBACK [ WORK ]
None.
Closes all cursors not opened WITH HOLD.
"COMMIT statement" on page 420
"ROLLBACK TO SAVEPOINT statement" on page 598
A transaction is the logical unit of work done on one database connection to
a database between COMMIT or ROLLBACK statements. The ROLLBACK
statement ends the current transaction and undoes all changes made to the
database since the previous COMMIT or ROLLBACK.
♦
SQL/92 Entry level feature.
♦
Sybase Supported by Adaptive Server Enterprise.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
To Next Page
Loading...