Persisted Primary Key?
-
Friends, Iam using Persisted Primary key constraint for one column in a table. while creating another table using of the above table column as reference constraint getting the following error. "There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key." How could I resolve this issue?
-
Friends, Iam using Persisted Primary key constraint for one column in a table. while creating another table using of the above table column as reference constraint getting the following error. "There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key." How could I resolve this issue?
What database are you using, candidate key does not sound familiar.
Never underestimate the power of human stupidity RAH
-
What database are you using, candidate key does not sound familiar.
Never underestimate the power of human stupidity RAH
-
Friends, Iam using Persisted Primary key constraint for one column in a table. while creating another table using of the above table column as reference constraint getting the following error. "There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key." How could I resolve this issue?
-
Eddy Vluggen wrote:
A persisted column, that'd be a computed/calculated field? Are you sure that's a good idea to use as a primary key?
It shouldn't even be allowed in my opinion
"The ones who care enough to do it right care too much to compromise." Matthew Faithfull