Re: Finding info on Constraints

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: 2000/07/01
Message-ID: <1rl75.724$8m.3318@typhoon.tampabay.rr.com>#1/1

The last piece you are looking for is in user_indexes:

User_constraints tells you what primary key the foreign key is referencing. User_cons_columns tells you which columns in the child table are referencing the primary_key.
User_indexes tells you what columns make up the primary key.

John Alexander
Summit Software Design

Harriett Xing <harriettxing_at_my-deja.com> wrote in message news:8jj2li$sp6$1_at_nnrp1.deja.com...
> Hello,
>
> I just got a database where all constraints are created with the
> default names 'SYS_Cxxxxxx'. USER_CONSTRAINTS can tell me what type
> they are, USER_CONS_COLUMNS indicates a column. How can I find the
> complete info on a foreign key constraint? ie, the column it belongs
> to and the column it references?
>
> Btw, I have no access to any visual modeling tool.
>
> Thank you for your help.
> Harriett Xing
> HarriettXing_at_my-deja.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jul 01 2000 - 00:00:00 CDT