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
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

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.