Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Recursive SQL to drop and add Foreign Key constraints

Recursive SQL to drop and add Foreign Key constraints

From: Andy Smith <andy.smith_at_citicorp.com>
Date: 1997/03/21
Message-ID: <3332710A.2855@citicorp.com>#1/1

-- 
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
Received on Fri Mar 21 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US