15.00 - Enforcing Referential Integrity in Teradata - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.