SQL
卤蛋哥
热爱IT行业
展开
-
SQL Server 删除所有存储过程
DECLARE @STRING VARCHAR(8000) WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE TYPE='P' AND STATUS>=0) BEGIN SELECT TOP 1 @STRING='DROP PROCEDURE '+ NAME FROM SYSOBJECTS WHERE TYPE = 'P' AND STATUS>=原创 2011-11-20 15:51:03 · 413 阅读 · 0 评论 -
sql server删除所有表
use [a0905010239] 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)原创 2011-11-20 15:47:28 · 294 阅读 · 0 评论