15.00 - Transition Tables - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Transition Tables

A transition table is a dynamically created table that you can reference using a correlation name.

The following table indicates the type of rows that are contained by a transition table depending on the triggering statement that caused the transition table to be created.

 

This triggering statement …

Generates a transition table containing the following row set …

DELETE

old rows only.

INSERT

new rows only.

  • UPDATE
  • MERGE UPDATE
  • both old and new rows.

    The following table documents the rows that can be referenced in a transition table depending on trigger granularity.

     

    This trigger granularity …

    References rows for this transition table …

    Row

  • NEW [ROW]
  • NEW TABLE
  • NEW_TABLE
  • Statement

  • OLD [ROW]
  • OLD TABLE
  • OLD_TABLE
  • OLD_NEW_TABLE
  • OLD_NEW_TABLE is valid only for AFTER UPDATE triggers.