Droping Stored Procs using Wildcards

Last Post 09 Aug 2007 05:03 PM by ffabbroc. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ffabbroc
New Member
New Member

--
31 Jul 2007 04:35 PM
I'd like to be able to drop a set of similarly named stored procs in a script, without having to name each stored proc individually, because I won't know all the names in advance.

Is there a way to do this in a query using wildcards?

For example, let's say I have 10 stored procs that all begin with the name "f_foo_". Is there a way to script a drop statement that essentially does:

drop procedure f_foo_*

Thanks
ffabbroc
New Member
New Member

--
09 Aug 2007 05:03 PM
Pro Pete, you are a pro! That's exactly what I was looking for...Thanks!
You are not authorized to post a reply.

Acceptable Use Policy