CODEWITHSUNDEEP
mysql-workbench
StackOverflowNewbie
StackOverflowNewbie

Reputation: 40633

MySQL Workbench - how to display relationships?

How do I make Workbench display the connecting lines between tables when I define relationships?

Upvotes: 24

Views: 72935

Answers (5)

Cyrois
Cyrois

Reputation: 479

I had an issue generated a PNG with the relationship lines.

Environment

  • WorkBench version 8.0
  • MacOS Mojave 10.14.5 with Dark Theme

Solution:

Disable dark theme and regenerate the diagram then export the PNG.

Upvotes: 13

Eugen Konkov
Eugen Konkov

Reputation: 25133

You need to open reverse engineer: Database->Reverse engineer CTRL+R

Complete the wizard. It ask about the database to connect and other simple questions.

Just click Next.

After wizard completion the MySQL Model tab will be opened. Click there ERR Diagram icon

Upvotes: 14

Tanuj
Tanuj

Reputation: 567

You need to check draw line box

You need to check draw line box.

Upvotes: 5

Tom
Tom

Reputation: 1271

MySQL Workbench has three options for relationship visibility settings:

  • Fully Visible
  • Draw Split
  • Hide

It sounds like you need to switch from Draw Split to Fully Visible. Double click on the endpoint, such as the crows feet. On the Relationship tab of the edit window you will is the Visibility settings.

Upvotes: 1

Sergio
Sergio

Reputation: 4567

When you edit a table in an EER model, you will have a tab named Foreign Keys that allows you to define well... the foreign keys. These foreign keys will be visible in the diagram.

You can change the settings for the displayed relationship by double clicking on the line that connects the tables.

Upvotes: 6

Related Questions