Re: Alter Table

On Thu, 2007-03-15 at 08:35, Shavonne Marietta Wijesinghe wrote:
> When i alter a table and add a new column it always adds it to the end
> of the table. Is there any way to tell it to add the new column at the
> 5th position or to add the new column after a surtain column.

No, but the good news is you can just recreate the table once it's
stabilized in form with something like:

create table new_table as select field1, field4, field2, field3 from
old_table;