CREATE SCHEMA `MY_DB_1` DEFAULT CHARACTER SET utf8 ; CREATE SCHEMA `MY_DB_2` DEFAULT CHARACTER SET utf8 ; CREATE TABLE `MY_DB_1`.`MY_TABLE_1` ( `id` INT NOT NULL, PRIMARY KEY (`id`)); CREATE TABLE `MY_DB_1`.`MY_TABLE_2` ( `foreignKeyColumn` INT NULL, INDEX `foreign_KEY_1_idx` (`foreignKeyColumn` ASC), CONSTRAINT `foreign_KEY_1` FOREIGN KEY (`foreignKeyColumn`) REFERENCES `MY_DB_1`.`MY_TABLE_1` (`id`)); RENAME TABLE `MY_DB_1`.`MY_TABLE_1` TO `MY_DB_2`.`MY_TABLE_1`; RENAME TABLE `MY_DB_1`.`MY_TABLE_2` TO `MY_DB_2`.`MY_TABLE_2`;