16.20 - OLD TABLE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update
Equivalent introductions to a table correlation name for the old values transition table.
OLD TABLE is the form specified by the ANSI SQL-2011 standard.
OLD_TABLE is a Teradata extension retained for backward compatibility.
You can specify OLD_TABLE or OLD TABLE references in both statement triggers and row triggers.
You can specify a normalize Period column for OLD TABLE or OLD_TABLE.
OLD_TABLE and OLD TABLE are valid only for DELETE, MERGE UPDATE, and UPDATE triggering events.
AS old_transition_table_name
Table alias name specified with the OLD TABLE or OLD_TABLE options for referencing the transition table of old values.
The AS keyword preceding old_transition_table_name is optional.