Anyone know why a foreign key constraint would NOT be generated?
I have the version 184.108.40.206 of Toad Modeller for SQL Server 2008 R2 database.
Some of the relationships I have defined in my model are not getting generated as foreign key constraint
ALTER TABLE xyztable ADD CONSTRAINT relxyzfield FOREIGN KEY ([xyzfield) REFERENCES abctable ([abcfield]) ON UPDATE NO ACTION ON DELETE NO ACTION
I have compared the ones that are being generated and I can’t find anything different.