摘要: 一、删除数据库中的所有用户表 1 declare @nameTemp varchar(100) 2 declare myCursor cursor for 3 select name 4 from sysobjects 5 where xtype = 'U' 6 and name 'sysdiagrams' 7 open myCursor 8 fetch next from myCursor 9 into @nameTemp10 while @@fetch_status = 011 begin12 exec('drop table ' + @na 阅读全文
posted @ 2013-07-13 00:12 pkray 阅读(456) 评论(0) 推荐(0) 编辑