This statement is only supported on the Block File System on the primary cluster. It is not available for the Object File System.
Terminates and rolls back the current transaction.
For information about the temporal form of ROLLBACK, see Temporal Table Support, B035-1182.
ANSI Compliance
ROLLBACK is ANSI SQL:2011-compliant.
The following ROLLBACK options are Teradata extensions to the ANSI standard:
- stop_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.