一次删除所有表SQL语句
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | 一次删除所有表SQL语句如下: declare @tname varchar (8000) set @tname= '' select @tname=@tname + Name + ',' from sysobjects where xtype= 'U' select @tname= 'drop table ' + left (@tname,len(@tname)-1) exec (@tname) 删除所有存储过程的sql语句 用到游标 declare @procName varchar (500) declare cur cursor for select [ name ] from sys.objects where type = 'p' open cur fetch next from cur into @procName while @@fetch_status = 0 begin if @procName <> 'DeleteAllProcedures' exec ( 'drop procedure ' + @procName) fetch next from cur into @procName end close cur deallocate cur |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步