15.00 - Transition Tables - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.