On Thu, Nov 03, 2005 at 05:10:44PM +, Richard Huxton wrote:
> Craig wrote:
> >Hi
> >
> >How can I query for all the tables that are referenced by a particular
> >table (i.e my table has 3 foreign keys. I need a query that will return
> >the table names of the referenced tables)?
>
> See the
Craig wrote:
Hi
How can I query for all the tables that are referenced by a particular
table (i.e my table has 3 foreign keys. I need a query that will return
the table names of the referenced tables)?
See the chapters on the "Information Schema" (which is an SQL standard)
and the "system
Hi
How can I query for all the tables that are
referenced by a particular table (i.e my table has 3 foreign keys. I need a
query that will return the table names of the referenced tables)?
Thanks
Craig