摘要：
删除表use 数据库名declare mycur cursor local for select [name] from dbo.sysobjects where xtype='U'declare @name varchar(100)OPEN mycurFETCH NEXT from mycur into @nameWHILE @@FETCH_STATUS = 0 BEGIN exec('drop table ' + @name)FETCH NEXT from mycur into @nameEND CLOSE mycur删除视图use 数据库名declare 阅读全文
posted @ 2011-06-01 13:11 yjss 阅读(3927) 评论(0) 推荐(3) 编辑