2013年11月2日
mssql批量删除数据库里所有的表
摘要： 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=0beginexec('drop table ['+@tbname+']')fetch next from #tb into @tbnameendclose #tbdeallocate # 阅读全文
posted @ 2013-11-02 23:26 microsoftzhcn 阅读(367) 评论(0) 推荐(0)