--- In firebird-support@yahoogroups.com, "Simon Carter"
<mail.lists@...> wrote:

>
> Does anybody have a sql script which will allow me to easily see

what stored

> procs are not referenced by another stored proc, without having to

check the

> dependencies for each proc?

It might be more useful to write a script to recursively trace the
dependencies of a stored procedure, but for your scenario, I imagine a
check on the procedures where no dependency record exists would suffice:

Something like (read: not tested)

select P.RDB$PROCEDURE_NAME
from RDB$PROCEDURES P
where NOT exists
(
SELECT 1
FROM RDB$DEPENDENCIES D
WHERE P.RDB$PROCEDURE_NAME = D.RDB$DEPENDED_ON_NAME
)


Adam