Home -> Usenet -> comp.databases.oracle -> How can I reconstruct foreign key constraints from data dictionary tables?

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

From: Peter Wazinski <wazinski_at_fid.freinet.de>
Date: 1995/05/05
Message-ID: <3ocl5b$t8v_at_bock.freinet.de>#1/1 






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?




Any ideas?



Peter



wazinski_at_fid.freinet.de
Received on Fri May 05 1995 - 00:00:00 CEST












Original text of this message