Adding or Dropping Referential Constraints - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

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.