Re: SQL query for foreign keys?

From: Stan Brown <stanb_at_panix.com>
Date: 31 Jul 2001 09:42:36 -0400
Message-ID: <9k6ckc$nvd$1@panix3.panix.com>

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?

Hi, I had to make a little trip for the past week, or so, and ho usenet access during this time.

I am still unable to get this working. Could anyone provide further insigth as to how to acomplish this?

What I am trying to do is determinet where to allow free form input, and where to force the user to select from a list of existing choices here. Received on Tue Jul 31 2001 - 08:42:36 CDT