mercredi 3 février 2016

sqlite howto sort columns?

when I look at my large table in a sqlite file, using an sqlite browser such as Firefox plugin SQLite Manager or the SQLite Browser, I see that the columns are shown according to their sequence of addition to the table (I have been adding new columns in a loop).

A   J   D   B
--- --- --- ---
..  ..  ..  ..

this is a visual annoyance because the table is very large has many many columns, and for the purpose of debugging, I need to visually check neighboring columns. How can I sort the table so that the columns are sorted, like:

A   B   J   D
--- --- --- ---
..  ..  ..  ..

thanks.

Aucun commentaire:

Enregistrer un commentaire