Hope that helps You can not do this programatically (in a safe way that is) without creating a new table. What Enterprise Manager does when you commit a reordering is to create a new table, move the data and then delete the old table and rename the new table to the existing name.
How do I reorder data.table columns?
By : Yuriy Volosenko
Date : March 29 2020, 07:55 AM
it should still fix some issue How do I permute columns in a data.table? I can do that for a data.frame, but data.table overrides the method: , Use setcolorder:
hop of those help? This isn't a trivial task in any DBMS. You would almost certainly have to create a new table with the order that you want, and move your data from one table to the order. There is no alter table statement to reorder the columns, so either in sqlite manager or any other place, you will not find a way of doing this in the same table. If you really want to change the order, you could do: