When I add a new column and directly add the foreign key in the same alter statement by specifying the schema of the target column it should keep the schema name in the generated SQL When I add a new ...
check show create, the symbol is differenet. child_3_ibfk_1 and fk_child_3_1 # src mysql SQL> SHOW CREATE TABLE child_3; child_3 | CREATE TABLE `child_3` ( `id` int(11) DEFAULT NULL, `parent_id` ...