Thread: Column Ordering

On 9/10/07, Ashish Karalkar <ashish.karalkar@info-spectrum.com> 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.

That doesn't make sense.  dropping and recreating the table isn't
really constrained by column ordering.  Now, if you've got FK
constraints, other triggers, rules, etc... then I can see those being
an issue.

> Is there anyway to do so.

Not without dropping and recreating the table OR creating an updatable
view on top of it.