Hi all,

I need to unload & reload data from one database to another (same
schema), and I need a way to disable the foreign key constraints while
importing the data.

I have a feeling that the only way to do this is to drop the foreign
keys w/ a ALTER TABLE statement, and I would like to write a utility
to drop the foreign keys & to add them back when I'm done importing
the data, but I don't know how to get all the info needed to recreate
the foreign keys. Specifically, I don't know how to tell if a foreign
key has cascading updates/deletes.

How can I do this?

Thanks for any suggestions!