WITH NO CHECK OPTION - Advanced SQL Engine - Teradata Database

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)