OSEC

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

From: Kwok Peng Tuck (pengtuckmakmal.net)
Date: Wed Jul 02 2003 - 20:49:12 CDT

I think for your insert it is better if you specify the columns with the
appropiate values you want to insert. Then you have a better and precise
control of what values go into what columns without worying about the
ordering of the columns.

dhaylexmark.com 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?
>
>Many thanks,
>
>David
>
>
>
>_______________________________________________
>sapdb.general mailing list
>sapdb.generallistserv.sap.com
>http://listserv.sap.com/mailman/listinfo/sapdb.general
>
>
>
>

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