0

I'm reverse-engineering a database and specifying relationships. MySQL workbench wants add foreign-key columns as I do this.

While I see the benefit of this, I would like to turn off this default behavior since the columns already exist (just using a different name than what Workbench is expecting).

I'm using Mysql 5.5.49 and Workbench 6.3.6 on Ubuntu if that makes any difference.

asked Jan 30, 2018 at 15:45

1 Answer 1

0

When you create a relationship you can use one of the tools reachable with the buttons in the vertical toolbar (or the hotkeys 1-6). The last one (enter image description here) is what you are looking for. It let's you pick the columns to be used for a relationship instead of creating new columns for it.

answered Jan 31, 2018 at 7:39
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.