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

能不能一次清空数据库中所有记录请问有没有比较简单的方法一次清空数据库内的所有数据？(100个表左右)--给你个存储过程create PROCEDURE droptable0 asDECLARE @tbName varchar(50)DECLARE @rowcnt intDECLARE @sqls nvarchar(4000)DECLARE curName CURSOR forSELECT name FROM sysobjectsWHERE xtype = 'U' AND status > 0ORDER BY name OPEN curNameFETCH NEXT FROM curName INTO @tbNameWHILE @@fetch_status=0BEGIN set @sqls='select @a=count(*) from [' @tbname ']'exec sp_executesql @sqls,N'@a int output',@rowcnt outputif @rowcnt=0 exec('drop table [' @tbname ']')FETCH NEXT FROM curName INTO @tbName ENDclose curnameDEALLOCATE curName--执行存储过程exec droptable0刪除數據庫，再重建數據庫可以嗎、sp_MSforeachtable 'delete ?'是不是要這樣http://community.csdn.net/Expert/topic/3927/3927769.xml?temp=.2954981导出表结构，然后drop table ，再重新导入。用powerdesigner，几分钟就搞定