16.20 - Adding or Dropping Referential Constraints - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

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.