Referential Constraints | Data Types and Literals | Teradata Vantage - 17.10 - Referential Constraints - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

Use referential constraints to indicate relationships between columns of different tables. There are three specific types of referential constraints.

Referential Constraint Type DDL Definition Does It Enforce Referential Integrity? Level of Referential Integrity Enforcement
Referential constraint REFERENCES WITH NO CHECK OPTION No None
Batch referential integrity constraint REFERENCES WITH CHECK OPTION Yes Request
Referential integrity constraint REFERENCES Yes Row