>-- disable referential integrity >EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' >GO > >EXEC sp_MSForEachTable 'TRUNCATE TABLE ?' >GO > >-- enable referential integrity again >EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL' >GO >Hmmm, I run the following:
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' GO EXEC sp_MSForEachTable 'TRUNCATE TABLE ?' GO EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'and I get
Cannot truncate table 'dbo.aspnet_Roles' because it is being referenced by a FOREIGN KEY constraint.