15.00 - Referential Integrity Constraints - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.

  • Standard (see “Standard Referential Integrity Constraints” on page 562).
  • Batch (see “Batch Referential Integrity Constraints” on page 562).
  • Referential Constraint (see “Referential Constraints” on page 563).
  • 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.