一 清空数据库里所有的表
复制代码 代码如下:
declare @tablename varchar(50)
declare @truncatesql varchar(255)
declare trcun_cursor cursor for
select [name] from sysobjects where type = ‘u’
–有条件的清空表 name<>’不想清空的表名’–
open trcun_cursor
fetch trcun_cursor into
@tablename
while(@@fetch_status = 0)
begin
set @truncatesql = ‘truncate table ‘ + @tablename
–exec(@truncatesql) –当要删除时,就去掉–
print @truncatesql
fetch trcun_cursor into @tablename
end
close trcun_cursor
deallocate trcun_cursor
二 清除数据库里的所有数据
exec sp_msforeachtable “truncate table ?”