17.00 - WITH NO CHECK OPTION - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

Referential integrity is not to be enforced for the specified primary key-foreign key relationship.

For a column attribute foreign key constraint, specify this clause as follows.

REFERENCES WITH NO CHECK OPTION referenced_table_name 
                               (referenced_column_name)

For a table attribute foreign key constraint, specify this clause as follows.

FOREIGN KEY (referencing_column_name) REFERENCES WITH NO CHECK             OPTION (referenced_table_name referenced_column_name)