17.10 - Referential Integrity Constraints - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

Vantage supports referential integrity constraints between candidate key column sets of a parent table and foreign key column sets of a child table. Both explicitly declared PRIMARY KEY constraints and alternate key constraints are supported.

You can define multiple referential integrity constraints for a table.

Vantage supports the following types of referential integrity constraints.

If a referential integrity constraint is defined where either or both of the tables have row-level security constraints, execution of the referential integrity constraint does not execute any security policy UDFs defined for the table. Execution continues as if the tables were not row-level security-protected.