MySQL Bugs: #53502: Show Column data types and NULL-ability in the Object Browser

Bug #53502	Show Column data types and NULL-ability in the Object Browser
Submitted:	7 May 2010 17:47	Modified:	11 Nov 2011 2:18
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

Description:
Add a folder under Tables for Columns and shove the columns in there and then also show a folder for Triggers to display triggers on that table.

How to repeat:
Open Object Browser, expand any database with tables in it, expand Tables, expand any
table. Notice that each column in the table is listed however you cannot tell it's data type or whether it is NULL-able from the listing.

Thank you for the feature request.

My apologies, my browser or the application must have resent my previous post's data in the Description field. It should read:

Next to each column name show the column's data type and "NULL" or "NOT NULL" depending on it's NULL-ability.

Fixed as of 5.2.36:

+        The table information window within the <guilabel>Object
+        Browser</guilabel> has been expanded to include foreign keys,
+        triggers, indexes, and data types.