Re: Finding info on Constraints

Just noticed I mentioned the wrong view - should have said user_ind_columns to get the columns that make up the primary key.

John Alexander <jalexander_at_summitsoftwaredesign.com> wrote in message news:1rl75.724$8m.3318_at_typhoon.tampabay.rr.com...
> 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