How can we help you today? How can we help you today?

New FK not created with name

Have an issue where source has FK but target does not.
Am getting a working ALTER TABLE statement, but the ALTER does not include the FK name, which means I get whatever MySQL wants to generate for me.

Don't really like this. Would prefer that the newly created FK have the same name as my Source.

Is there any way to do this??

Here's what MySQL Compare gives me:
ALTER TABLE `acquisition` ADD FOREIGN KEY (`character_id`) REFERENCES `player_character` (`character_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

What I would prefer:
ALTER TABLE `acquisition` ADD CONSTRAINT `fk_player_character_to_acquisition` FOREIGN KEY (`character_id`) REFERENCES `player_character` (`character_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

Thanks!
bmoore86
0

Comments

2 comments

Sort by
  • Eddie D
    Hi
    Thank you for your forum post.

    I suspect that MySQL Compare has read the information from the metadata within a system file and created the ALTER TABLE statement in the format you do not like.

    I have submitted a Bug Report for the Development Ream to consider, the Bug Report reference is MSC-67. Also a Support Ticket has been created for you HERE, call reference #10162.

    I will update this post when I receive further information.

    Many Thanks
    Eddie
    Eddie D
    0
  • Eddie D
    Hi

    Believe this bug is now fixed in MySQL Compare v1.0.0.672 which can be downloaded using this LINK.

    Many thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.