--系统存储过程 select name from sysobjects where xtype='P' and category=2--用户自定义存储过程 select name from sysobjects where xtype='P' and category=0--删除所有用户自定义存储过程 declare @sql varchar(8000) set @sql='' SELECT @sql=@sql+'drop proc '+NAME+char(13) FROM SYSOBJECTS WHERE xtype='P' and category=0 exec(@sql)
select name from sysobjects where xtype='P' and category=2--用户自定义存储过程
select name from sysobjects where xtype='P' and category=0--删除所有用户自定义存储过程
declare @sql varchar(8000)
set @sql=''
SELECT @sql=@sql+'drop proc '+NAME+char(13) FROM SYSOBJECTS
WHERE xtype='P' and category=0
exec(@sql)