Referential Integrity Constraints
Teradata Database 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.
Teradata Database supports 3 different 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.