16.20 - NEW 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 new values transition table.
NEW TABLE is the form specified by the ANSI SQL:2011 standard.
NEW_TABLE is a Teradata extension retained for backward compatibility.
You can specify NEW_TABLE or NEW TABLE references in both statement triggers and row triggers.
You cannot specify a normalize Period column for NEW ROW TABLE or NEW_TABLE.
NEW_TABLE and NEW TABLE are valid only for INSERT, MERGE INSERT, MERGE UPDATE, and UPDATE triggering events.
AS new_transition_table_name
Table alias name specified with the NEW TABLE or NEW_TABLE options for referencing the transition table of new values.
The AS keyword preceding new_transition_table_name is optional.