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.