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
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