How to fix the ALTER TABLE statement conflicted with the FOREIGN KEY constraint

Asked Nov 23 '19 at 12:59

Active Nov 24 '19 at 02:56

Viewed 2,337 times

Unable to create a relationship 'FK_Sales_Date'.

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Sales_Date". The conflict occurred in database "SalesDataWarehouse", table "dbo.Date", column 'DateKey'.

edited Nov 24 '19 at 02:56

Lin Du

88,126
95
281
483

asked Nov 23 '19 at 12:59

Kumudika Bamunu Arachchige

How to fix the ALTER TABLE statement conflicted with the FOREIGN KEY constraint

0 Answers0