Generating Foreign Keys

From: Oliver Staats <ostaats_at_optusnet.com.au>
Date: Tue, 7 Dec 1999 19:23:26 +1100
Message-ID: <82igk3$g8$1@news1.mpx.com.au>

Hi all

I have a set of tables from a legacy system, that have primary keys but no foreign keys. It seems to me that it should be possible to write some plsql to generate the foreign keys by taking the column names of each primary key and match them to the column names in other tables. Have any of you done this or better still got a script you might share with me?

Thanks in advance

Oli Received on Tue Dec 07 1999 - 02:23:26 CST