Re: Dependency Map

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