Re: Dependency Map

I see. Thanks.

On 11/6/20, Fred Toussi via Hsqldb-user
<[email protected]> wrote:
> EXPLAIN REFERENCES aggregates the same basic information that is reported in
> INFORMATION_SCHEMA.
>
> On Fri, Nov 6, 2020, at 17:18, Jorge Garcia de Alba wrote:
>> 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
>>
>
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>


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