MySQL Bugs: #66309: Alter table does not show order of fields in foreign key or index used

Bug #66309	Alter table does not show order of fields in foreign key or index used
Submitted:	10 Aug 2012 15:50	Modified:	10 Aug 2012 17:10
Reporter:	Bob Dankert	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.41	OS:	Windows (W7 32/64)
Assigned to:		CPU Architecture:	Any
Tags:	ALTER TABLE, Froeign key, INDEX, order

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The order of fields in a foreign key is not shown when altering the table.  It also does not show the index that is being used by the foreign key.  These are two pieces of information that can be helpful in certain situations.

How to repeat:
Create a multi-field foreign key, go in and look at it in the editor.  It doesn't show the order of the fields in the FK and it doesn't show which index is being used by the FK.

Suggested fix:
Show the order of the fields in the FK similarly to how they are shown for an index.  Also show the index being used by the FK.