Terminates and rolls back the current transaction.
For information about the temporal form of ROLLBACK, see Teradata Vantage™ - Temporal Table Support , B035-1182 .
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.