Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Display the comment of a column in the data tab

thadin's profile image thadin posted 6 years ago in Feature discussion Permalink
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.
LutzT's profile image LutzT posted 6 years ago Permalink
We have exactly the same scenario.
A tool tip would on a table column be really great....
Thanks & regards,
Lutz
ansgar's profile image ansgar posted 6 years ago Permalink
The data grid should already display column comments in their headers, like in the attached screenie. Isn't that the case for you?
1 attachment(s):
  • column-comments
LutzT's profile image LutzT posted 6 years ago Permalink
Your're right - I moved my mouse to fast over it...
It works - perfect!
thadin's profile image thadin posted 6 years ago Permalink
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.
ansgar's profile image ansgar posted 6 years ago Permalink
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.
LutzT's profile image LutzT posted 6 years ago Permalink
An astrisk might be confusing and interpreted as part of the name...
How about italic font?
thadin's profile image thadin posted 6 years ago Permalink
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"
ansgar's profile image ansgar posted 6 years ago Permalink
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.
byman64's profile image byman64 posted 1 month ago Permalink

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.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.