Ashish Karalkar wrote:
> Hello All,
>
> I am having a table with 5 columns.
> I want to add another column by altering the table at 2nd position
> constraint is that I can not drop and recreate the table as column
> ordering is of importance.
> Is there anyway to do so.
Copy everything into a tmp table, drop the original, recreate it with
the new column in the correct position, and move the data back into it.
brian