Re: [GENERAL] Column Ordering

2007-09-10 Thread Scott Marlowe
On 9/10/07, Ashish Karalkar <[EMAIL PROTECTED]> 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 mak

Re: [GENERAL] Column ordering

2007-09-10 Thread brian
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,