how to change column order

shri · General User Joined: 07 Dec 2004 Posts: 25

Hi
I have a table (with about 18 columns in it). Some columns were added later on.
I would like change the order of the columns, so that the related columns are next to each other. (I know for relational queries this does not matter, but for visual inspection I want to see the related columns togther).
I tried to drag the columns to proper places (where I wanted them), but that did not work.
It seems that the only way is to drop the table and recreate it (with the proper order for creating columns).
Is there any easier way?
Thanks
- shri

Lazy-legs · Posted: Sat Apr 23, 2005 2:17 pm Post subject:

Here is an idea: create a query or a view. Then you can rearrange columns via simple drag-and-drop.

Kind regards,
Dmitri
_________________
http://code.google.com/p/writertools/

rnelson · Power User Joined: 08 Mar 2005 Posts: 66 Location: Denver

Query views are nice, but this product is so infantile that the ability to edit or insert from a query is not yet available.

I've had to copy and past the table definition and data to a new table and reorder the fields before creating. I've been able to sometimes preserve the original table name by deleting the original then copying the copy to the original table name

very inconvenient and quite kludgy solution for a great product

r