I'm always struggling with this seemingly simple thing: refreshing the table view so that I can see the most current table structure (columns, keys, etc.). Very often I change a table structure and save the ALTER TABLE code in a version control system so that on my other computer I can reproduce the changes (and for other developers). But every time I run ALTER TABLE from the query tab it's a pain to make Heidi reflect the new table structure. The refresh button doesn't work - when I put focus on the table view then this button does nothing. When I focus on the tree view, it refreshes the tree view only. When I right click on the table name in the tree view and select refresh, also the tree view only gets refreshed. Most often I have to refresh the tree view, navigate away to a different table and come back my table to see the changes but it doesn't work consistently and I'm never really sure when Heidi updates the view.
Is there a way to refresh the table view in a sure and consistent way? Probably there should be another refresh button for refreshing the table structure, or perhaps a separate drop-down under the existing button. At least right click on a table name -> refresh should really refresh the table.