15.10 - Referential Constraints - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1143-151K

Use referential constraints to indicate relationships between columns of different tables. There are three specific types of referential constraints.

 

Referential Constraint Type

DDL Definition

Does It Enforce Referential Integrity?

Level of Referential Integrity Enforcement

Referential constraint

REFERENCES WITH NO CHECK OPTION

No

None

Batch referential integrity constraint

REFERENCES WITH CHECK OPTION

Yes

Request

Referential integrity constraint

REFERENCES

Yes

Row

You cannot specify REFERENCES constraints for Identity columns.

For additional information about REFERENCES constraints, see:

  • “ALTER TABLE” and “CREATE TABLE” in SQL Data Definition Language.
  • “Referential Integrity” in SQL Fundamentals.
  • “Constraint Specifications” in Database Design.