Re: Column Ordering

--- Andres Ledesma <alchir(at)yahoo(dot)com> wrote:
> Forgive me if I'm wrong but as far as I know, in the relational theory behind the RDBMSs, the
> colum order in a tupple is irrelevant, like the elements in a set.

This is correct.

> Is there any solid reason or need for having colunms ordered ?

My guess for this request is that alot of people would rather write:

SELECT *
FROM Table;

instead of:

SELECT column1, column5, column2, column3, column4
from Table;

I've seen alot of "BEST PRACTICE" advice on this list that suggests that writing out all of the
columns is recommended. However, I am sure that there are alot of individuals that like to write
these queries with the least amount of code possible.

Regards,
Richard Broersma Jr.