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.
expecting the columns to be in a specific order is a "no no". you should generate full insert statement when exporting the data.
I know that mysql has an "ADD column AFTER currColumn" in their ALTER TABLE syntax. How do we do this in SAP?
There was long discussion on the PostGreSQL mailing list which i started. After that discussion, they added a TODO, so PostGreSQL might become the first DBMS where you can redefine column-order.
Would be interesting to know, why SAPDB doesn't offer any way to re-order the columns. As far as i know, the "ADD column AFTER column" of MySQL affects the physical order of the columns - that's a stupid idea, and you have to "re-insert" a column to change its position.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
