CODEWITHSUNDEEP
mysqlconstraintsreferential-integrity
opensas
opensas

Reputation: 63635

mysql disable referential integrity

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?

Upvotes: 10

Views: 10227

Answers (2)

ruakh
ruakh

Reputation: 183612

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS company;

DROP TABLE IF EXISTS computer;

SET FOREIGN_KEY_CHECKS = 1;

Upvotes: 16

BluesRockAddict
BluesRockAddict

Reputation: 15683

This should work:

SET @@foreign_key_checks = 0;

DROP TABLE IF EXISTS company;
DROP TABLE IF EXISTS computer;

SET @@foreign_key_checks = 1;

Upvotes: 19

Related Questions