Bug #66226 Foreign Keys do not show up in object browser
Submitted: 6 Aug 2012 19:08 Modified: 7 Sep 2012 7:13
Reporter: Bob Dankert Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.41 OS:Any (W7 32, Mac OS X)
Assigned to: CPU Architecture:Any
Tags: foreign keys, Object Browser

[6 Aug 2012 19:08] Bob Dankert 
Description:
The list of foreign keys for a table do not show up in the object browser.  You have to go into the alter table interface to get this information.

How to repeat:
Expand the Foreign Keys section under Object Browser on a table with foreign keys, notice that nothing shows up.

Suggested fix:
Populate the foreign keys.  Also, when a foreign key is selected, it should display all of the information regarding that foreign key in the information pane.
[6 Aug 2012 19:48] Valeriy Kravchuk 
Thank you for the bug report. Verified with 5.2.41 on Mac OS X also.
[7 Sep 2012 7:13] Philip Olson 
Fixed as of the upcoming Workbench 5.2.43, and here's the changelog entry:

 The object browser did not display foreign keys. A workaround
 was to view them via the "Alter Table" interface. 

Thank you for the report.
[26 Sep 2012 6:22] Mikko Torniainen 
This bug still exists in 5.2.43 for foreign keys that include more than one column. 
FOREIGN KEY (`foreign_apple`, `foreign_orange`) REFERENCES `fruit` (`apple`, `orange`)

The constraints are still visible via alter table.