Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reorgs
The following script creates foreign keys based on a common field name.
You will need to create your primary key first.
/*
filename: make_foreign_keys.sql
author: rbunting
ddl created: 27-Sep-95
remarks: Creates a file of possible foreign keys for all tables that have the same column name.*/
where t.column_name = upper('&&COLUMN') and o.object_type = 'TABLE' and t.table_name = o.object_name
Robert Bunting
Missouri Employer's Mutual
Columbia, Mo
314-499-4135
On Mon, 8 Jan 1996, Ian wrote:
> Hello all
>
> Can you help me with a neat way to create foreighn key constraints
> from an existing database ( to help with object-by-object
> reorganisations )
>
> .
> i
>
Received on Mon Jan 08 1996 - 13:05:01 CST