Re: SQL query for foreign keys?

From: Stan Brown <stanb_at_panix.com>
Date: 31 Jul 2001 14:58:02 -0400
Message-ID: <9k6v3q$g63$1@panix3.panix.com>

In <3B66F559.991E5DA1_at_attws.com> "Daniel A. Morgan" <Daniel.Morgan_at_attws.com> writes:

>Stan Brown wrote:

>> In <9ji6v7$j2m$1_at_panix2.panix.com> stanb_at_panix.com (Stan Brown) writes:
>>
>> >Given a table name column name pair, what query can I run against the
>> >system tables to find out:

>> >1. If it has a foreign key.
>> >2. If so, what the table name column name pair that it's key resieds in?
>>
>Here's a view I built years ago that did it for a schema named 'OMS2':

Thanks, I appreciate the help. Received on Tue Jul 31 2001 - 13:58:02 CDT