Hi Rob,

> -----Original Message-----
> SELECT DISTINCT dep.RDB$Field_Name AS FieldName FROM
> RDB$Dependencies dep WHERE UPPER(dep.RDB$Depended_On_Name) =
> 'CLIENTCUSTOM'
>
> Is this safe to use? In my results I get the field I knew
> was in use by a stored procedure which is good. However I
> also get a dependency with no field name, what does this mean?

AFAIK, you will always get a blank field, this gives you a physical
dependency, i.e. obj1 depends on obj2. Where a fieldname is specified it is
done to indicate where the actual dependency exists. If that makes sense
:-)

Take a peek at (http://www.fbtalk.net/viewtopic.php?id=213) for a proc which
gives you slightly more info on dependencies.

hih

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://www.tectsoft.net/ - Homepage