17.10 - Referential Integrity Enforcement - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1141-171K
Language
English (United States)
The 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.