sql question

[Jonathan Ellis]

On Tue, 12 Jul 2005 16:11:05 -0600, "Merrill Oveson" <moveson at gmail.com>
said:
> Anybody know of sql statement where I can select all the columns
> except one or two.
> 
> I.e.  Instead of this:
> 
>    select a,b,c,d,e,f,g,h,i,j,k,l,m,n from foo
> 
> I could do this:
>  
>    select *, except m,n from foo
> 
> possible?
> 
> I'm using sqlserver and mysql

There isn't one.  Using "select *" is usually considered poor form since
someone reading your code has to refer to the table definition to see
what comes back; the same would apply to your hypothetical statement as
well.

-Jonathan