1. SET FOREIGN_KEY_CHECKS=0;
  2. SET FOREIGN_KEY_CHECKS=1;
  3. ALTER TABLE table_name DISABLE KEYS;
  4. ALTER TABLE table_name ENABLE KEYS;
  5. ALTER TABLE table_name1 DROP FOREIGN KEY fk_name1; ALTER TABLE table_name2 DROP FOREIGN KEY fk_name2;