SQL query to select all columns in a table except two columns

Question

I have a table in ms-access with column names A to H

TableA 

A   B  C  D  E  F G  H

how can i write a query to select all columns except B and F columns. Query result should be

A C D E G H

Do we have something like this

select * from TableA except B, F ?

Answer 1

Nope, you're stuck with

select a, c, d, e, g, h from TableA

Answer 2

select A, C, D, E, G, H from TableA

Answer 3

You can't do this. It is '*' or just the fields you specify. Is this a big problem? Or is it just that you want something "neater"?

Answer 4

No, we don't. You have to use

SELECT A, C, D, E, G, H 
FROM TableA

And this is good if you ask me. SELECT * is evil enough.

Answer 5

I don't know for sure, but it's definitely better to explicitly specify the columns you want to select. This makes any potential changes to your table easier to live with as you can use aliases etc.

Answer 6

select A, C, D, E, G, H from TableA or create a view and select from that as below CREATE VIEW vTableA as
select A, C, D, E, G, H from TableA