10

I want to drop all the schemas in a mysql db, and I don't want to be bothered with referential integrity errors

in h2 it's done like this

SET REFERENTIAL_INTEGRITY FALSE; drop table if exists company; drop table if exists computer; SET REFERENTIAL_INTEGRITY TRUE;

How can it be achieved in mysql?

Improve this question
1
  • thanks a lot, both solutions worked, I just selected the first one as correct, and upvoted both... Commented Mar 31, 2012 at 20:28

2 Answers 2

Reset to default
19

This should work:

SET @@foreign_key_checks = 0; DROP TABLE IF EXISTS company; DROP TABLE IF EXISTS computer; SET @@foreign_key_checks = 1;
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

16 
SET FOREIGN_KEY_CHECKS = 0; DROP TABLE IF EXISTS company; DROP TABLE IF EXISTS computer; SET FOREIGN_KEY_CHECKS = 1;
Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.