|
|
Posted by Erland Sommarskog on 10/01/33 11:26
David Portas (REMOVE_BEFORE_REPLYING_dportas@acm.org) writes:
> In a production application table column order is mostly unimportant -
Yes, if no humans ever look at the database - which is highly unlikely
if the system is in production.
I just get so tired of this. Everytime someone asks about placing a column
in a certain order in a table, there is always someone knowledgable who
needs to tell that person he does not need to do that.
Column order *does* matter, because it makes it so easy to work with.
The fact that SQL Server does not provide any simple command to change
order is no reason to tell people they want the wrong thing.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|