Re: Dependency Map

Found the information needed in information schema. What additional
information does "EXPLAIN REFERENCES TO TABLE" provide?

Jorge

On 11/4/20, DD <[email protected]> wrote:
> 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