Retrieve all columns except 1 in a table.

I have a table with 20 columns and I have to retrieve 19 except one.
Is there any way easier then giving
SELECT Col1,Col2,Col3,..........Col19 from table1.

Showing Answers 1 - 4 of 4 Answers

mohit Goyal

Oct 4th, 2011

SELECT * [except columnA] FROM tableA

dilbagh

Oct 9th, 2011

select top 19 * from table1

bhanu

Nov 23rd, 2011

if we are dong select top 33* from table, we will get topmost 33 records but not the all 33 columns except 1 column in a table.