Re: Dependency Map

On 4/11/2020 17:52, Jorge Garcia de Alba wrote:
> Hello,
>
> I am interested in building a dependency map that shows relationships
> between procedures and functions in a schema. Does anybody have code
> that will do that? Thanks.
>
> Jorge
>
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

/¡Buendia!/

I started that a while back. Fred Toussi gave me some clues.

I broke off because of stuff that needed doing & this job needs space to 
work in. I was having a lot of trouble getting my head round recursion 
(LOL).

You may have advanced further. My sole aim was to plug in a table name 
and find all the dependencies. I am not sure that your concept will show 
much without also referencing views and tables.

Here is the thread I started so you can see how far I'd got and decide 
if it relates to your requirement:

https://sourceforge.net/p/hsqldb/discussion/73674/thread/c438d8553b/?limit=25#b774

/Saludos/

David

-- 
D Denny
Trujillo - Perú

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user