First, I connect 2 tables with 1 to many relationship. Workbench correctly creates FK column in the child table.

1-When I change the name of the PK in the parent, the old FK name remains unchanged in the child.

2-The name generated for the fk is not following the standard pattern set in the options (even when using the defaults).

Any suggestions to keep names in sync? (besides me performing the manual change)?

Note: I am using Workbench 6.3 Community Edition.

  • 1
    If you're just working with the model (before you actually deploy the model and make the database out of it), removing the relationship removes also the FK is dropped. I have just tested right now with WB 6.3.6 build 511 CE – joanolo Feb 11 '17 at 12:07
  • @joanolo, thank you for your comment. I will check my version vs. yours. – NoChance Feb 11 '17 at 12:39
  • @joanolo, you are correct, I have no idea why I had some old fks left around? However, I tried it again and it works correctly. Thx. – NoChance Feb 12 '17 at 18:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.