sql游标--删除所有的表

      在此同时求点击：点击点击点击。。。

----sql游标--删除所有的表


declare @tablename varchar(100)
Declare cur_tablename Cursor For Select [name] From sysobjects  where  type='U' and [name] like 'dnt_%'
Open cur_tablename 
Fetch next From cur_tablename Into @tablename
While @@Fetch_Status=0 
Begin 


exec('drop table '+@tablename) 


Fetch From cur_tablename into @tablename 
End 
Close cur_tablename 
Deallocate cur_tablename 


----sql游标--删除所有的存储过程
declare @tablename varchar(100)
Declare cur_tablename Cursor For Select [name] From sysobjects  where  type='P' and [name] like 'dnt_%'
Open cur_tablename 
Fetch next From cur_tablename Into @tablename
While @@Fetch_Status=0 
Begin 


exec('drop proc '+@tablename) 


Fetch From cur_tablename into @tablename 
End 
Close cur_tablename 
Deallocate cur_tablename