17.10 - Adding or Dropping Referential Constraints - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

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

Referential Constraints provide the Optimizer with an efficient method for producing better query plans that take advantage of defined, but unenforced, referential relationships.

Other than not enforcing referential integrity and not requiring the candidate key for the referenced table in the constraint to be explicitly declared to be unique, the rules for Referential Constraints (Referential Constraints are sometimes called soft referential integrity constraints.) are identical to those documented by Adding or Dropping Standard Referential Integrity Constraints. See Referential Constraints for additional information.