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)