OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Migration problem - where is ADD columnName AFTER command?

dhaylexmark.com
Date: Wed Jul 02 2003 - 14:38:52 CDT


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?

Many thanks,

David

_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general