Re: How to add 2 columns to a table with After ColName???

2005-03-15 Thread Roger Baklund
mos wrote: I've tried just about every syntax combination to try and add columns to a table using Alter Table and I keep running into syntax errors. Alter table MyTable add (newcol1 float after col3, newcol2 float after col3); or Alter table MyTable add (newcol1 float, newcol2 float) after

How to add 2 columns to a table with After ColName???

2005-03-14 Thread mos
I've tried just about every syntax combination to try and add columns to a table using Alter Table and I keep running into syntax errors. Alter table MyTable add (newcol1 float after col3, newcol2 float after col3); or Alter table MyTable add (newcol1 float, newcol2 float) after col3; Of course