disabling contraints? - 11-11-2004 , 06:29 PM
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!