Truncating tables with foreign key constraints

• ATLDBA

  SSC Veteran

  Points: 227

  More actions

  March 26, 2004 at 1:44 pm

  #82481

  What is the best way to truncate a table with many Foreign Key Constraints without deleting the relationships?  Is this possible?

  Thanks!

  
  Carpe diem!

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 26, 2004 at 1:51 pm

  #500746

  You can disable them but only for UPDATES and INSERTS, not DELETES from what I find and BOL and have seen firsthand.

• Ned

  Ten Centuries

  Points: 1214

  More actions

  March 26, 2004 at 3:34 pm

  #500769

  See the thread "Delete Large records 20 million rows!!! FAST" in this forum. It might give you some good ideas.