truncate and load

• sathiyan00

  SSCommitted

  Points: 1879

  More actions

  January 16, 2013 at 3:33 am

  #272836

  Hi all,

  Is there any way to truncate and load the data when the tables have relationships.

  like disabling all the constraints at one time .

  truncating ,loading all data

  then enabling all constraints

  thanks

  sathiyan r

• Ant-Green

  SSC Guru

  Points: 113504

  More actions

  January 16, 2013 at 4:38 am

  #1577748

  You would need to loop through dropping all the FK's, then truncate, then load then recreate the FK's

  Just setting the constraint to NOCHECK still wont allow you to truncate the referenced table.