Posted By

ironcrema on 04/05/14

Tagged

sql
server

Versions (?)

Last Edited at 04/05/14 02:16am

Statistics

Viewed 766 times

Favorited by 0 user(s)

Related snippets

Drop store procedures by name contains

/ Published in: SQL

Drop store procedures

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

DECLARE @procName VARCHAR(500)
DECLARE cur cursor 
 
FOR SELECT [name] FROM sys.objects WHERE TYPE = 'p' AND name LIKE '%sp_%'
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