The current time is

Thursday, December 18, 2008

There are no primary or candidate keys in the referenced table

Couple of days back... I got this error
"There are no primary or candidate keys in the referenced table 'dbo.Table01' that match the referencing column list in the foreign key 'FK_Table01_Table02'."

Although the column list in the first table DO MATCH the column list in the second table with the same data types...

After alot of investigations, my collegue and I discovered it has to do with the order of columns being referrenced... Never thought that this matters... but this solved the issue... :)))

No comments:

Post a Comment