sql server - Unable to create diagram -


i'm getting error:

'category' table saved successfully
'author' table saved successfully

'product' table - unable create relationship 'fk_product_author'. alter table statement conflicted foreign key constraint "fk_product_author". conflict occurred in database "sample_1", table "dbo.author", column 'authorid'.

how can fix ??

i suppose have information in database , try create diagram.

you have inconsistence between product , author tables, mean, have authorid inside product table dooes not exist in author table, when try create foreign key, can't create it.


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -