Subject Re: [firebird-support] Termine presense of SP
Author Helen Borrie
At 08:21 AM 21/09/2004 +0000, you wrote:
>Hi
>
>I would like to know if a stored procedure (I know the name of the
>procedure) is present in the DB.
>Can I do that ?

select 1 from rdb$procedures
where rdb$procedure_name = 'YOUR_PROCEDURE'

./heLen