Reorder columns in table and/or data editor?

[jeffcwolf]

Hi, first of all, a big thank you for creating this tool. I've been looking for a long time for a database browser for sqlite that provides the functionality with foreign keys (associated name columns, etc) that you have built in. And many of the other features, but that's what I was specifically looking for in a tool that supports sqlite (this is not possible in db browser for sqlite, for instance).

This is probably a newbie question, but I would have thought there was a simple way to drag and drop the order of columns in a table, e.g. moving the third column to the last position? I tried doing this in 'open structure' and in the Tables, Views, Functions pane, but no luck. The same is true for the columns in the data table view. I would not need to rearrange the order of the underlying table columns, if I could simply do that in the data table view, for instance (to facilitate data entry).

Of course, I can simply write some SQL to do this, but the easiest way would be drag and drop right in the data table view, I think - just as we can do with the tabs as it is now.

Now, maybe I just haven't found out how to do this yet...we'll see!

Thanks for the great application and your hard work maintaining it.

-JW