Re: constraints and foreign keys

From: Robin Aylesworth <raylesworth_at_metasolv.com>
Date: 1996/09/12
Message-ID: <01bba0d1$6e444ec0$1202010a_at_ws-robina.metasolv.com>#1/1


You can try this:

select table_name,column_name from sys.dba_cons_columns;

Good luck-

Robin Aylesworth

maevans <maevans_at_io.com> wrote in article <50l46d$i4d_at_anarchy.io.com>...
> I've got several referencial constraints attached to tables. How do I
> get the table name and column name of the the constraint for a particular
> table? I'm sure its simple but it eludes me...
>
Received on Thu Sep 12 1996 - 00:00:00 CEST

Original text of this message