Re: How to reorder fields in a table

ewarmoth wrote:

> 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

The order of fields in a table is irrelevant to any process so I'd just forget it and not try to make a lot of work for yourself.

If you drop a table of course the data is lost. You can, of course, rename the table then use its contents to load the new table before dropping it.

But it is still a waste of time and introduces risk without any possible benefit.

Daniel A. Morgan Received on Mon Jul 23 2001 - 15:34:42 CDT