清空数据库里所有的表的数据
use 你要清空的库godeclare @tbname varchar(250)declare #tb cursor for select name from sysobjects where objectproperty(id,IsUserTable)=1open #tbfetch next from #tb into @tbnamewhile @@fetch_status=0begin
·
use 你要清空的库 go declare @tbname varchar ( 250 ) declare #tb cursor for select name from sysobjects where objectproperty (id, ' IsUserTable ' ) = 1 open #tb fetch next from #tb into @tbname while @@fetch_status = 0 begin exec ( ' delete from [ ' + @tbname + ' ] ' ) fetch next from #tb into @tbname end close #tb deallocate #tb
汇聚全球AI编程工具，助力开发者即刻编程。
更多推荐
0
0- 0
已为社区贡献3条内容
所有评论(0)