in navicat you can arrange the order of the columns but i have yet to find a way to sync the changes with the database. i saw a similar question here -> Rearrange column order in Sqlyog but haven't found anything similar in navicat. i have many tables that need to be fixed for export to excel and the order is important in the readability/presentation. typing out sql code for each move would be way too tedious. thanks in advance.
This is a really old question i Stumbled on going to answer just in case someone needsNavicat provides the ability to change the column order in a table by using the design table feature Either right click on the table name or press ctr-d on the top of the screen there are arrows to move a column up or downBy pressing on the SQL preview tab on the top you can actually see the ALTER TABLE statements navicat is going to runYou can also copy-paste this Statement and run on any other test database you may have or as a git migrationIts a good idea to always read the SQL Preview as some times Navicat may use DROP statements and you would want to take a backup before something like that
I used to start Navicat from Bash till I figured out the solution.To add Navicat to the menu, create a Launcher item in /usr/share/applications. Change the Exec line to match the path where you unzipped navicat. The solution has nothing to do with wine.
760c119bf3