SQL query, include all fields except specific fields

  • Thread starter Thread starter Guest
  • Start date Start date
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;
 
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;
Click to expand...


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.
 
Back
Top