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

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
tpf1598412463935.ditamap
dita:ditavalPath
tpf1598412463935.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢

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