Subject RE: [firebird-support] Detecting dependancies
Author Si Carter
Hi Rob,

> -----Original Message-----
> SELECT DISTINCT dep.RDB$Field_Name AS FieldName FROM
> RDB$Dependencies dep WHERE UPPER(dep.RDB$Depended_On_Name) =
> 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 ( for a proc which
gives you slightly more info on dependencies.


Si Carter - Web Based Firebird Forum - FBUtils - Homepage