Database columns order in Database Manager

I am using wappler 7.0.3 It's great but I have a problem with databases and table columns. I added a column to a table and wappler put the column at the very end of my columns, How can I move that column to the right spot in the list?

1 Like

Good question! I'm not sure if Wappler has a built-in feature for that, but I found this:

I tried the MySQL workbench and it worked and moved the column but when I went in to wappler did a refresh and the table was the same.
Also
On another topic when I used a font Awesome logout image the one I picked was a bracket then arrow wat was placed on the page was an arrow then bracket is this right?
thanks joe

Actually the column order in a sql database doesn’t matter. The order is also just as you create them. If you add a new column then it appears at the end.

To fully enforce a reorder then the whole table need to be destroyed and recreated, which is really not needed because it doesn’t make any difference but the visual aspect only.

This was a weird thing when we started using PostgreSQL over MySQL.
Mssql has the same behaviour but, there is an option in their DB tool SSMS to do the drop and recreation automatically, to allow putting columns wherever we want.

Over the years, have overcome this weirdness of not being able to manage sequence of columns.
Its still a pain to search for the right column when viewing data or building queries visually in Wappler, but have gotten used to it.

I have a feature request to sort them alphabetically if that's what you're after.