SQL query, include all fields except specific fields

G

Guest

In a SQL query, is there any way to include all fields on a table excluding a
specified list of fields? For example, something like:

select
* (exclude=var1,var2,var3)
from
table_name;
 
M

Marshall Barton

David said:
In a SQL query, is there any way to include all fields on a table excluding a
specified list of fields? For example, something like:

select
* (exclude=var1,var2,var3)
from
table_name;


No. List the fields you do want.

If your tables have so many columns that it's a problem, it
may be that the table needs to be normalized.

OTOH, you can select all the fields in the table and drag
them to the query, and then delete the ones you don't want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top