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.
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.