Delete / Drop all stored procedures in an SQL Database
The following SQL will delete all stored procedures in a specified database. Make sure you specify the database you are using! USE [MyDatabase] DECLARE @spName varchar(500) DECLARE _CurCursor CURSOR FOR SELECT [name] FROM sys.objects WHERE type = ‘p’ OPEN _CurCursor FETCH NEXT FROM _CurCursor INTO @spName WHILE @@fetch_status = 0 BEGIN EXEC(‘DROP PROCEDURE ‘ + … Delete / Drop all stored procedures in an SQL Database
