multi-table-delete

SQLMenace’s solution worked for me with a slight tweak to how data is deleted – DELETE FROM instead of TRUNCATE. — disable referential integrity EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’ GO EXEC sp_MSForEachTable ‘DELETE FROM ?’ GO — enable referential integrity again EXEC sp_MSForEachTable ‘ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL’ GO