16.20 - Referenced (Parent) Table - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageâ„¢ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

A child table must have a parent, and the referenced table is referred to as the parent table.

The parent key columns in the parent table are the referenced columns.

For standard and batch RI, the referenced columns must be one of the following unique indexes:

  • A unique primary index (UPI), defined as NOT NULL
  • A unique secondary index (USI), defined as NOT NULL

Soft RI does not require any index on the referenced columns.