Re: Migration problem - where is ADD columnName AFTER command?

[Kwok Peng Tuck]

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.

[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?
Many thanks,

David



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
 

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general