Posted by Chung Leong on 03/24/06 04:01

Rainman wrote:
> Is there a non-tedious way to get around this? The tedious way is to
> list each column name in the SELECT list (instead of *) using "AS" to
> rename appropriate fields, but with so many columns returned, this will
> be a headache, especially since these tables are still evolving.

Nope, there is no method other than using column aliases that I know
of. It's not a terribly good practice to use SELECT * in a program in
any event, since you would end up retrieving columns that won't be
used. For instance, when you join two tables, you obviously wouldn't
need to fetch both the primary and the foreign key.

[Back to original message]