Physical reordering of columns is absolut not necessary. Wy do you need to know in wich order comes the columns ?? You can specify the order in selects, update and inserts. A programm wich need to know the exact physical order of columns has devinitiv a wrong design!
You are absolutely right. I'd like to "re-order" columns, just to keep my DB-design clean, nothing more nothing less. I won't ever use "SELECT *" or INSERT without column-names in my applications and i don't tolerate if others use that in their applications.
Offering the user the possibility to re-define the column-order is just s service, but can can also be used to seperate "logical" from "physical" column-order. Perhaps the physical column-order can be optized to gain some performance.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
