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_*