请注意，如果您设置了任何参照完整性，则 TRUNCATE 将不起作用.

Note that TRUNCATE won't work if you have any referential integrity set.

在这种情况下，这将起作用:

In that case, this will work:

EXEC sp_MSForEachTable 'DISABLE TRIGGER ALL ON ?'
GO
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
GO
EXEC sp_MSForEachTable 'DELETE FROM ?'
GO
EXEC sp_MSForEachTable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL'
GO
EXEC sp_MSForEachTable 'ENABLE TRIGGER ALL ON ?'
GO

明确地说，语句中的?是一个?.它被 sp_MSForEachTable 过程替换为表名.

To be clear, the ? in the statements is a ?. It's replaced with the table name by the sp_MSForEachTable procedure.