MySQL Bugs: #101565: Add feature to order / reorder foreign keys

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:	None
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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

Hello Karsten Wutzke,

Thank you for the reasonable feature request!

regards,
Umesh