Re: How to reorder fields in a table

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Mon, 23 Jul 2001 17:59:36 GMT
Message-ID: <cCZ67.7$Rg7.1094@news2.news.adelphia.net>

Well, if you really feel you must have them in order, you can export the table, drop it, recreate it with the fields in the order you want and then import (specify that you want to ignore errors where object already exists).

But, why?

"ewarmoth" <ewarmoth_at_hotmail.com> wrote in message news:3B55E6A0.CE081CB8_at_hotmail.com...
> When I alter a table to add new fields, the fields are put at the end of
> the table. Is there a way to add a field between two existing ones? Or
> am I stuck with them at the end?
>
> If I were to drop the table and re-create it, I would lose the data,
> right?
>
> Thanks very much,
> Emily
Received on Mon Jul 23 2001 - 12:59:36 CDT