sybase 'drop procedure'. can I get it to take a parameter instead of a naked proc name?
- by Michael Wilson
Happy Monday o/
I'm looking to do the following within a stored proc
select @parameter="fooproc"
drop procedure @parameter
instead of
drop procedure fooproc
But it's choking with a syntax error. Is there some way I can bend this to my will? I would've expected to be able to do this.
I've tried a few permutations of type declaration of @parameter to no avail.
Thoughts?