Editing Rollback (data management) (section)

==SQL==
SQL refers to Structured Query Language, a kind of language used to access, update and manipulate database.
In [[SQL]], <code>ROLLBACK</code> is a command that causes all data changes since the last <code>START TRANSACTION</code> or <code>BEGIN</code> to be discarded by the [[relational database management systems]] (RDBMS), so that the state of the data is "rolled back" to the way it was before those changes were made.<ref>{{Cite web|url=https://www.sqlshack.com/rollback-sql-rolling-back-transactions-via-the-rollback-sql-query/|title=Rollback SQL: Rolling back transactions via the ROLLBACK SQL query|author=Ben Richardson|date=26 December 2019|access-date=16 April 2022}}</ref>

A <code>ROLLBACK</code> statement will also release any existing [[savepoint]]s that may be in use.

In most SQL dialects, <code>ROLLBACK</code>s are connection specific.  This means that if two connections are made to the same database, a <code>ROLLBACK</code> made in one connection will not affect any other connections.  This is vital for proper [[Concurrent programming|concurrency]].