Re: How can I reconstruct foreign key constraints from data dictionary tables?

In article <3ocl5b$t8v_at_bock.freinet.de>, Peter Wazinski <wazinski_at_fid.freinet.de> writes:
>I have created a table like
>
> create table test(
> test_col number constraint fk_test
> references test2(test_col2));
>
>How can I reconstruct fk_test by examining the data dictionary
>tables, e.g. user_constraints or user_cons_columns?
>
>I have only been able to find out that test_col points to a column
>in table test2 but I couldn't figure out the name of the column?

        desc user_cons_columns ->

         Name Null? Type

• -------- ---- OWNER NOT NULL VARCHAR2(30) CONSTRAINT_NAME NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) COLUMN_NAME NOT NULL VARCHAR2(30) POSITION NUMBER

        David.

-- 

   _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
   David Cure - Ifremer/Brest - SISMER - BP70 - 29280 PLOUZANE - FRANCE
     Email : David.Cure_at_ifremer.fr / Tel : 98.22.46.42 - 98.22.42.10
           WWW : http://www.ifremer.fr/sismer/sommaire.htm

   " Apres avoir vu la lumiere, on ne retourne pas dans les tenebres "