16.10 - Referential Integrity Enforcement - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Release Number
June 2017
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

Teradata Database supports two forms of declarative SQL for enforcing referential integrity:

  • A standard method that enforces RI on a row-by-row basis
  • A batch method that enforces RI on a statement basis

Both methods offer the same measure of integrity enforcement, but perform it in different ways.

A third form, sometimes informally referred to as soft RI, is related to these because it provides a declarative definition for a referential relationship, but it does not enforce that relationship. Enforcement of the declared referential relationship is left to the user by any appropriate method.