DECLARE proccur CURSOR
FOR
SELECT [name]
FROM sysobjects
WHERE type = ‘P‘
DECLARE @procname VARCHAR(100)
OPEN proccur
FETCH NEXT FROM proccur INTO @procname
WHILE ( @@FETCH_STATUS = 0 )
BEGIN
EXEC(‘drop proc ‘ + @procname)
PRINT ( @procname + ‘已被删除‘ )
FETCH NEXT FROM proccur INTO @procname
END
CLOSE proccur
DEALLOCATE proccur
原文：http://www.cnblogs.com/ljsjxr/p/5526109.html