15.10 - WITH NO CHECK OPTION - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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)