Re: Recursive SQL to drop and add Foreign Key constraints

From: John Hough <q6y_at_ornl.gov>
Date: 1997/03/21
Message-ID: <333295EF.8C9@ornl.gov>#1/1

Andy Smith wrote:
>
> --
> I'm going to rebuild some Primary Key (indexes) constraints and
> need some scripts that will go through the database and produce
> ALTER TABLE statements for dropping and re-creating the Foreign Key
> constraints.
>
> Does anyone have any scripts to this sort of thing ?
>
> Regards
> =================================================================
> Andy Smith Email: andy.smith_at_citicorp.com

Andy:

I believe I saw some scripts to do excactly this in the "Code Depot" of the Oracle Magazine web page. It is located at URL: http://www.oramag.com

Hope this helps,

John Hough Received on Fri Mar 21 1997 - 00:00:00 CST