|
In database technologies, a rollback is an operation which returns the database to some previous state. Rollbacks are important for database integrity, because they mean that the database can be restored to a clean copy even after erroneous operations are performed.
In SQL, ROLLBACK is a command that causes all data changes since the last COMMIT, BEGIN WORK, START TRANSACTION, or ROLLBACK to be discarded, so that the state of the data is "rolled back" to the way it was before those changes were made.
In most SQL dialects, ROLLBACKs are connection specific. This means that if two connections are made to the same database, a ROLLBACK made in one connection will not affect any other connections. This is vital for proper concurrency.
See also
External links
|
