Purpose
Terminates the current transaction and rolls back its updates.
For information about the temporal form of ABORT, see Temporal Table Support .
Required Privileges
None.
Syntax
Syntax Elements
- abort_message
- Text of the message to be returned when the transaction is terminated.
- FROM option
- A clause that is required only if the WHERE clause includes subqueries or if the request is preceded with a temporal qualifier.
- WHERE abort_condition
- A clause that introduces a conditional expression whose result must evaluate to TRUE if the transaction is to be rolled back. The expression can specify aggregate operations and scalar subqueries.
ANSI Compliance
ABORT is a Teradata extension to the ANSI SQL:2011 standard. It is a synonym for the ANSI SQL:2011-compliant statement ROLLBACK (see “ROLLBACK”).