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.
- Standard (see Standard Referential Integrity Constraints).
- Batch (see Batch Referential Integrity Constraints).
- Referential Constraint (see Referential 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.