Select all columns of table accept one

[wEb GuRu]

Hi Dears I want to ask that if there is some query some thing like it "select * accept oneColumn from table" I want to do this bcz there r many columns in table and i dont want to write the names of all.If i dont want to select one column what can i do................ Thanking you in anticipation Take it easy...

[Marc Soleda]

I don't think it's possible: the WHERE clause limits rows nor columns. So you'll have to list all the columns ... unless you want to use a bit of script/prequery that gets a list of all columns and then build a new query based on that. Marc Soleda. ... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.

[Rob Graham]

There is no syntax support for this in SQL. You can select all (*) or a list. if you want to exclude a column you will have to type the entire list. You could create a view in the database the excludes that column, and select * from the view... Or you could select * from the table and just not use/display the column you aren't interested in. Absolute faith corrupts as absolutely as absolute power Eric Hoffer All that is necessary for the triumph of evil is that good men do nothing. Edmund Burke

[mtasaad]

if you are using front end then limit the width size to zero. for that the columns you don't like to display.