MySQL Forums :: Newbie :: drop all constraints, then reinstate all constraints??? is there a way to do this??


Advanced Search

drop all constraints, then reinstate all constraints??? is there a way to do this??
Posted by: Greg Hauptmann ()
Date: February 24, 2009 04:53AM

Is there a way in mysql to drop all constraints in one go, then reinstate all constraints again.

Background: I had to save data off and reinstall tables. Now I need to load data base the issue is the various foreign key constraints. I would love to be able to drop all constraints, load the the data, and then re-instate the constraints again.

Is this possible in mysql?

Thanks

Options: ReplyQuote


Subject Written By Posted
drop all constraints, then reinstate all constraints??? is there a way to do this?? Greg Hauptmann 02/24/2009 04:53AM
Re: drop all constraints, then reinstate all constraints??? is there a way to do this?? derek martin 02/24/2009 08:10AM
Re: drop all constraints, then reinstate all constraints??? is there a way to do this?? Greg Hauptmann 02/26/2009 06:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.