MySQL Forums
Forum List  »  Newbie

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??
February 24, 2009 04:53AM


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.