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

[10 Aug 2012 15:50] Bob Dankert
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.