Referential Integrity Error Tables for Column-Partitioned Tables - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
Referential integrity is supported only on the Block File System on the primary cluster, not on the Object File System.

This topic does not apply to the user-defined error tables described in the "Modifying Data Tables Defined with an Error Table" section of Rules and Restrictions for ALTER TABLE (Basic Table Parameters).

When you add a new referential constraint to a table, Vantage 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.