Menu
Is there any way to move a relationship arrow in an EER diagram in MySQL Workbench's data modeling tool? (without having to move or resize any table)
E.g. before:
After:
272
To see foreign key relationships of a column: SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA. KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'db_name' AND REFERENCED_TABLE_NAME = 'table_name' AND REFERENCED_COLUMN_NAME = 'column_name';
Enhanced Entity-Relationship (EER) diagrams are an essential part of the modeling interface in MySQL Workbench. EER diagrams provide a visual representation of the relationships among the tables in your model. Revisions made with the Model Editor are shown in the associated diagram.
(To view all the relationships in the sakila database, see Figure 9.35, “The sakila Database EER Diagram”.) Click the Properties tab of the panel on the lower left and then click one of the tables on the canvas. This action displays the properties of the table in the Properties window, as the next figure shows.
The relationships are laid out dynamically. You have only very limited control of that. The only layout adjustment you can do is to move the middle line in a 3-lines relationship:
Click on the line to make the grab handle visible and then drag that.
173
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
