The following table compares the three referential integrity constraint types supported by Teradata Database.
Referential Constraint Type | DDL Definition Clause | Does It Enforce Referential Integrity? | Level of Enforcement |
---|---|---|---|
Standard | REFERENCES | Yes | Single row |
Batch | REFERENCES WITH CHECK OPTION | Yes | All child table rows must match a parent table row. |
The different types have different applications, as the following table documents.
Referential Constraint Type | Application |
---|---|
Standard |
|
Batch |
|