|
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: Sven Koehler (skoehler
upb.de)
Date: Thu Jul 03 2003 - 07:26:01 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]