Column Ordering
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.
Thanks in advance.
With regards
Ashish...
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.