> 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 * from rdb$procedures
where rdb$procedure_name = 'YOURPROC'

Be aware of case-sensitive database object names, if you
are using them (hopefully not ;-)).


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com