truncate and load

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply