Bug #53503 Show Primary Keys and Foreign Keys in the Object Browser
Submitted: 7 May 2010 17:51 Modified: 26 Aug 2011 5:55
Reporter: Orlando Colamatteo Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.20 rev 5783 OS:Windows (Windows 7 64-bit)
Assigned to: CPU Architecture:Any
Tags: Object Browser, sql editor

[7 May 2010 17:51] Orlando Colamatteo 
Description:
Add a folder under Tables for Columns and shove the columns in there and then also show a folder for "Keys" to display Primary and Foreign Keys on that table. Related to Feature Request #53501.

How to repeat:
Open Object Browser, expand any database with a table in it that contains a primary key, expand Tables, expand a table with a primary key or foreign key on it. Notice that each column in the table is listed however you cannot tell if there is a primary key on the table or whether any columns in the table are a foreign key to another table.
[7 May 2010 17:58] Valeriy Kravchuk 
Thank you for the feature request.
[18 May 2010 13:22] Valeriy Kravchuk 
Bug #53725 was marked as a duplicate of this one.
[26 Aug 2011 5:55] Philip Olson 
This is fixed as of 5.2.32:

+ Primary and foreign keys are now displayed with different icons.