[GENERAL] Querying for related tables

[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