Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> script to dynmically create all foreign key constraints
hey there,
anyone have a script handy that generates sql to create all the
foreign key's in the database? Our client does not like ON DELETE
CASCADE to be left on. However, once in a while we need to use that
functionlity so I as going to drop the FK's in restricted session,
recreate them with ON DELETE CASCADE, perform the operation what
requires DELETE CASCADE, and then drop and recreate the FK's without
ON DELETE CASCADE. I know this sounds kind of hokey but the ON DELETE
CASCADE functionality is only ever required once every odd month so. I
know I can get the constraints from import export but I'd like a
dynaminc sql that I can just edit one and run.
Received on Tue Dec 10 2002 - 20:28:12 CST