Re: [Q] Foreign Keys

In article <3ev238$5ea_at_abacus.tis.tandy.com>, bpearc1_at_abacus.tis.tandy.com (Byron Pearce) wrote:

>I know that the table name and the name of the foreign key constraint
>are kept in the R_OWNER R_CONSTRAINT_NAME columns, but where is the
>name of the column on the referenced table that the FOREIGN KEY is
>referencing?

Not much help this. I have been trying to do this in a RPT recently. It looks
as you have to follow the constraint name through the views to find the columns for it in USER_CONS_COLUMNS. Havent had time to do this yet so don't know if it works ok.

rjj_at_dryland.demon.co.uk         Kalamazoo ANSWER Limited
rjj_at_ix.compulink.co.uk          Oracle Software House
                                All opinions are mine, all mine.