Bug #101565 Add feature to order / reorder foreign keys
Submitted: 11 Nov 2020 15:56 Modified: 12 Nov 2020 6:14
Reporter: Karsten Wutzke Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:8.0.21, 8.0.22 OS:Any
Assigned to: CPU Architecture:Any
Tags: foreign key, order

[11 Nov 2020 15:56] Karsten Wutzke
When editing a table in the DB model, the order of foreign keys cannot be changed.

It would be nice to be able to order/reorder them, as certain tools and/or plugins rely on the order, e.g. by interpreting the first foreign key in a join table as the forward direction etc.

How to repeat:
Take any table with multiple foreign keys, see order in the Foreign Key tab of the table. There's no way in WB to change the order.

Suggested fix:
It would be nice to be able to drag and drop the foreign keys around just like the order of columns is changed.
[12 Nov 2020 6:14] MySQL Verification Team
Hello Karsten Wutzke,

Thank you for the reasonable feature request!