删除所有存储过程
- 作者: 爱情游戏18644047
- 来源: 51数据库
- 2022-08-17
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
推荐阅读
