能不能一次清空数据库中所有记录

[luckyprg]

请问有没有比较简单的方法一次清空数据库内的所有数据？(100个表左右)

[sensorcsdn]

--给你个存储过程
create PROCEDURE droptable0 as
DECLARE @tbName varchar(50)
DECLARE @rowcnt int
DECLARE @sqls nvarchar(4000)
DECLARE curName CURSOR for
SELECT name FROM sysobjects
WHERE xtype = 'U' AND status > 0
ORDER BY name

OPEN curName
FETCH NEXT FROM curName INTO @tbName
WHILE @@fetch_status=0
BEGIN
set @sqls='select @a=count(*) from ['+@tbname+']'
exec sp_executesql @sqls,N'@a int output',@rowcnt output
if @rowcnt=0 exec('drop table ['+@tbname+']')
FETCH NEXT FROM curName INTO @tbName
END
close curname
DEALLOCATE curName

--执行存储过程
exec droptable0

[chenqianlong]

刪除數據庫，再重建數據庫可以嗎、

[wudan8057]

sp_MSforeachtable 'delete ?'

[talantlee]

是不是要這樣
http://community.csdn.net/Expert/topic/3927/3927769.xml?temp=.2954981

[ropriest]

导出表结构，然后drop table ，再重新导入。
用powerdesigner，几分钟就搞定