删除某个数据库所有表的数据

exec sp_msforeachtable 'alter table ? nocheck CONSTRAINT all' exec sp_MSforeachtable @command1='Delete from ?' exec sp_MSforeachtable @command1 = 'TRUNCATE TABLE ?'