Enforcing Referential Integrity in Teradata
To implement referential integrity (RI) in Teradata, you have three choices, ranked in their order of preference:
1 Use the declarative referential integrity constraint checks supplied and enforced by the database software.
2 Write your own, site-specific macros, triggers, or stored procedures to enforce RI.
3 Enforce constraints through application code.
See “CREATE TABLE” in SQL Data Definition Language Detailed Topics for a description of the problems inherent in attempting to enforce database integrity using nondeclarative constraints.