- 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
- EXEC('drop procedure ' + @procName)
- FETCH next FROM cur INTO @procName
- END
- CLOSE cur
- DEALLOCATE cur
- --该片段来自于http://www.codesnippet.cn/detail/190420132899.html
来源: http://www.codesnippet.cn/detail/190420132899.html