From: Sven Köhler (skoehlerupb.de)
Date: Wed Jul 02 2003 - 19:19:09 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

> 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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]