Making column editing table sortable

[expired user #9814]'s profile image [expired user #9814] posted 8 years ago in General Permalink

Currently, the grid that is used for altering tables is not sortable. Making it sortable is hugely useful. Lots of time I need to sort it by data type, column name, etc.

Thanks for awesome HeidiSQL.

ansgar's profile image ansgar posted 8 years ago Permalink

The column's list is intentionally sorted by their order in the table definition, and sorting is not possible so the user always sees the order in which they are created in the table. You can instead, move a column up and down, and you can filter them, when you have the filter panel active (Edit > Filter panel).

[expired user #9814]'s profile image [expired user #9814] posted 8 years ago Permalink

To make both d&d and sorting possible a simple toggle button to enable dragging could be added to columns toolbar. The order of table definition is shown by (#) column and if that order is needed by someone he can simply click on the that column's title.

Currently, when the number of column is not small, finding columns in column editor pane is not convenient at all.

btd, I think sorting is by far more useful than d&d

[expired user #9814]'s profile image [expired user #9814] posted 8 years ago Permalink

Any feedback regarding this post?

Also please note that none of other rdbms support column reordering that itself shows the importance of sorting over reordering.

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