Re: Select all fields except one

[Vivek Khera <khera(at)kcilink(dot)com>]

On Nov 28, 2007, at 11:06 AM, Matt Doughty wrote:

Is there a way of selecting all fields except for one in particular? I'd like to create a query that says something like:

 

select * except fieldx

 

For best practices, you should never use select * in your queries.  You will inevitably end up with code that cannot deal with a schema change, and for any live system, you will have a schema change at some point...

It is best to explicitly list the field names your code is expecting.  Besides, I don't think you can do what you want to do with just SQL.