[EMAIL PROTECTED] wrote: > > Hi, > > We're writing some migration code to update our database to a > new version > of our code. > > We need to add some columns, but insert them after a > particular column in > the table because we use "INSERT INTO table VALUES (...)" statements, > necessitating that the columns be in the right order. > > I know that mysql has an "ADD column AFTER currColumn" in > their ALTER TABLE > syntax. How do we do this in SAP? >
ADD column AFTER is not available in SAP DB. The only way is to - rename the old table - create the new one with the wanted columns in the wanted ordering - insert into new table select from old table (or do the last two steps in one) - do not forget to grant privs, create views, create indexes, create synonyms for the new table with the old name Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
