USE BASE_NAME DECLARE @sc varchar(max), @sp varchar(max) DECLARE cr CURSOR FOR SELECT ROUTINE_SCHEMA, SPECIFIC_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' OPEN cr FETCH NEXT FROM cr INTO @sc, @sp WHILE @@FETCH_STATUS = 0 BEGIN EXECUTE('DROP PROCEDURE ' + @sc + '.' + @sp) FETCH NEXT FROM cr INTO @sc, @sp END CLOSE cr DEALLOCATE cr