I am very new to the Sql Server. Currently I want to add the new foreign key to the already existing table in this table there is existing data in a column where I want to make the change.
I tried this approach on a table for a column where data is present and also for a column data does not exist. I have noticed where there is no data it works fine. Please find below the error message.
“The alter table statement conflicted with the foreign key constraint”.
Can someone guide me in fixing this foreign key error?