The current time is

Showing posts with label Foreign Key. Show all posts
Showing posts with label Foreign Key. Show all posts

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... :)))