Insert into a child table issue.

• ssa2010

  Old Hand

  Points: 365

  More actions

  April 11, 2014 at 3:14 am

  #148527

  I have 3 parent tables in sql2005 named as A, B, C.

  And the child table is D.

  D is referenced with these 3 parent tables.

  When I insert data into table D, foreign key reference error occured.

  The data for insert operation not found in the parent tables.

  How can I avoid these error and insert value into child table D.

• SQLCJ

  SSCommitted

  Points: 1791

  More actions

  April 11, 2014 at 3:20 am

  #1705161

  You want to bypass the foreign key constraint ... so question arises why do you have them in first place ?

  Probably disabling it temporarily should solve you problem .. you might want to take a look at

  http://technet.microsoft.com/en-us/library/ms175041.aspx

• ssa2010

  Old Hand

  Points: 365

  More actions

  April 11, 2014 at 3:33 am

  #1705164

  SQLCJ (4/11/2014)

  ---

  so question arises why do you have them in first place ?

  Because it is for a syncing tool