Re-ordering columns

Archived Topics
1

Is there a way to re-order the columns in a table. I found nothing in help files and the table customizer doesn’t allow it (unless I’m missing something). I even tried doing it in DB Tools but it won’t allow me to save changes. Thanks,

Norm

2

You just re-order them in your query:

SELECT A, B, C FROM MyTable
SELECT C, B, A FROM MyTable
3

Norm,

I’m not sure about any other databases, but in MySQL you can add a column in any spot you want by using the “AFTER” keyword. The MySQL Query Browser shows you the query when you alter a table, so I just copied an example here:ALTER TABLE `test`.`mytable` ADD COLUMN `newcol` VARCHAR(45) NOT NULL AFTER `mytable_ndx`; You can add a row, hit apply, and then copy the query and cancel it. Then change which column it’s after and execute.

The only problem with this is that it must be a new column, so you would have to remove the old one (and loose all its data) to add it again. This isn’t a problem in some cases, but for history tables, it’s pretty useless. Carl’s solution is definitely the best, but if you are set on using “SELECT *…” then there is this option.

4

Got it - thanks again for your help.

Norm