16.20 - About Referential Integrity Error Tables for Column-Partitioned Tables - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

This topic does not apply to the user-defined error tables described in Rules and Restrictions for Modifying Data Tables Defined With an Error Table.

When you add a new referential constraint to a table, Teradata Database generates a referential integrity error table. For a column-partitioned child table, this error table is a NoPI table with neither column nor row partitioning.

The referential integrity error table for a row-partitioned child table has the same primary index and row partitioning as the row-partitioned child table.