Subject RE: [firebird-support] Termine presense of SP
Author Thomas Steinmaurer
> 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