Child - Parent issue

• Carl Farmer

  SSCrazy

  Points: 2197

  More actions

  September 26, 2002 at 5:35 am

  #158501

  It lookslike some data has become corrupt on my db, and when trying to delete entries from a table - I get a message saying that I cannot delete child as no parent exists. Does anyone know how I can get around this?

  Thankyou.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  September 26, 2002 at 5:52 am

  #437298

  o you have a FK constraint in place? If so you may need to drop it until you clean up then add back.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)