| Subject | Re: [firebird-support] How to drop stored procedure from another stored procedure ? |
|---|---|
| Author | Milan Babuskov |
| Post date | 2007-09-07T16:11:18Z |
S?awek Cabaj wrote:
BEGIN
if (exists(select 1
from RDB$PROCEDURES where RDB$PROCEDURE_NAME = 'PROC'))
then
EXECUTE STATEMENT 'drop procedure PROC';
END
--
Milan Babuskov
http://fbexport.sourceforge.net
> Let's say I don't know is there in the database suchEXECUTE BLOCK AS
> procedure as PROC. I'd like to check it and if it is there to drop it.
BEGIN
if (exists(select 1
from RDB$PROCEDURES where RDB$PROCEDURE_NAME = 'PROC'))
then
EXECUTE STATEMENT 'drop procedure PROC';
END
--
Milan Babuskov
http://fbexport.sourceforge.net