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.

steve