Display the comment of a column in the data tab

We apply comments to table columns where it isn't possible to explain the content with the small column names or where the data might be misleading (due to additional calculations in the script).

HeidiSQL allows to view & modify these comments in the table structure tab but it would be nice to have it in the data tab as well. Possibly with a little icon next to the column name that you can hover to view the comment.

I've checked; the comment is available in the queries you run when opening the tab (SHOW CREATE TABLE `database`.`table`;) so it should be available there.

We have exactly the same scenario.
A tool tip would on a table column be really great....
Thanks & regards,
Lutz

The data grid should already display column comments in their headers, like in the attached screenie. Isn't that the case for you?

Your're right - I moved my mouse to fast over it...
It works - perfect!

I see, apparently I hovered over the wrong column. An additional icon would solve this "problem" and you'd have an extra motivation to check the comment when you're reading / exporting the data.

The current implementation will only show it to users who think the name is weird and have hope that somebody has put some explanation in the comment. The other use case, when the content might me misleading isn't really solved by this.
I don't know how many column comments are used in a typical database but we use it rarely, so an icon would make me curious what's special about this column and see any explanations / warnings.

Definitely right. If there was an additional icon, it would be much clearer that there is a comment. Unfortunately, the underlying tree/grid view control only supports one icon per column header. That's already a problem for index icons, sort glyphs and timestamp flag icons, from which only one is displayed.

Any alternative idea to an icon? Perhaps having an asterisk (*) in the column title? I guess that would be misleading.

An astrisk might be confusing and interpreted as part of the name...
How about italic font?

Can you enter all UTF8 characters? Maybe you can cheat with a text-as-icon character like Ɂ, ɂ, ҉ or Ⴔ

Depending on the charset you can look at other resources for "icons"

Yes, I can display all characters there. But I cannot right-align them really. A quirky way would be to calculate the current column width and then insert a fitting number of spaces after the column title and the comment character.

I also added some comments on columns and I can see them on DATA tab as tooltip for column heading.

Same tooltip seems not available on List of columns in the query panel, right panel. Mouse over on column name show the same column name and not comment.