Alan J Davies wrote:

> Hi, is it possible to get a list of UDFs and the various SPs that have a
> dependency on them, from rdb$.....?

rdb$dependencies

> I do know the udfs in each database, but its a long job to check each
> one individually.

It is simplest to ALTER all the procedures. Dump database DDL (using
FlameRobin, for example), copy/paste the ALTER PROCEDURE section and run it.

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================