Home Forums SQL Server 2008 SQL Server 2008 - General truncate and load RE: truncate and load
Ant-Green
SSC Guru
Points: 113445
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.