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
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