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.