ROLLBACK Statement | SQL Statements | Teradata Vantage - 17.05 - ROLLBACK - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
vnq1596660420420.ditamap
dita:ditavalPath
hoy1596145193032.ditaval

Terminates and rolls back the current transaction.

For information about the temporal form of ROLLBACK, see Teradata Vantage™ - Temporal Table Support , B035-1182 .

See also:
  • ABORT
  • COMMIT
  • Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142

ANSI Compliance

ROLLBACK is ANSI SQL:2011-compliant.

The following ROLLBACK options are Teradata extensions to the ANSI standard:
  • abort_message
  • FROM_clause
  • WHERE_clause
Other SQL dialects support similar non-ANSI standard statements with names such as the following:
  • ROLLBACK TRANSACTION
  • ROLLBACK WORK

Required Privileges

None.