Alan,

> -----Original Message-----
> IBExpert (and others) can show a tables dependencies I'm
> interested only in a table's dependence on other tables.
> RDB$DEPENDENCIES only lists a tables dependence on triggers
> and views but not other tables. There must be a more
> circuitous route to obtaining the number of tables a table is
> dependent on.
> Anyone know the SQL?

Try here (http://www.fbtalk.net/viewtopic.php?id=213)

Hih

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered Forum