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
Post a Comment