SQL SERVER 2005中删除数据库中所有表的数据的SQL语句:
EXECUTE sp_msforeachtable
'delete from ?'
或者:
EXECUTE
sp_msforeachtable
'
truncate table ?
'
转载于:https://www.cnblogs.com/fireice/archive/2009/08/18/1548787.html
转载于:https://www.cnblogs.com/fireice/archive/2009/08/18/1548787.html