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