Please find the table structures as below
CREATE TABLE Contact12
ContactID INT PRIMARY KEY,
CREATE TABLE Contact13
SalesOrderID INT PRIMARY KEY,
CONSTRAINT fk_Contact13_Sid FOREIGN KEY(ContactID) REFERENCES Contact12(ContactID)
I want to update contactid in contact12 table
want to update contact 1 with 19978
wrote a query it gives following error of course there is conflict
The UPDATE statement conflicted with the REFERENCE constraint "fk_Contact13_Sid". The conflict occurred in database "Ticket", table "dbo.Contact13", column 'ContactID'.
how to go about for such kind of updates.