Delete all stored procedures

No DECLARE @ procNameVARCHAR (500) DECLAREcurCURSORFORSELECT [name] FROMsys. Tables @ procNameWHILE @ fetch_status0BEGINEXEC (dropprocedure + @ procName) FE is deleted for all stored procedures.

No DECLARE @ procName VARCHAR (500) DECLARE cur cursor for select [name] FROM sys. objects WHERE type = 'P' OPEN curFETCH next FROM cur INTO @ procNameWHILE @ fetch_status = 0 begin exec ('drop procedure '+ @ procName) FE

Delete SQL statements for all stored procedures
<无>

 DECLARE @procName VARCHAR(500)DECLARE cur CURSOR FOR  SELECT [name]  FROM   sys.objects  WHERE  type = 'p'OPEN curFETCH next FROM cur INTO @procNameWHILE @@fetch_status = 0  BEGIN      EXEC('drop procedure ' + @procName)      FETCH next FROM cur INTO @procName  ENDCLOSE curDEALLOCATE cur