16.10 - Referential Integrity - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)

Referential integrity (RI) is defined as all the following notions.

  • The concept of relationships between tables, based on the definition of a primary key (or UNIQUE alternate key) and a foreign key.
  • A mechanism that provides for specification of columns within a referencing table that are foreign keys for columns in some other referenced table.

    Referenced columns must be defined as Primary key columns or Unique columns.

  • A reliable mechanism for preventing accidental database corruption when performing inserts, updates, and deletes.

Referential integrity requires that a row having a value that is not null for a referencing column cannot exist in a table if an equal value does not exist in a referenced column.