Re: [GENERAL] Querying for related tables

2005-11-03 Thread Jim C. Nasby
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

Re: [GENERAL] Querying for related tables

2005-11-03 Thread Richard Huxton
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

[GENERAL] Querying for related tables

2005-11-03 Thread Craig
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