Select * except one column 2

[ABerkowicz]

Hi - I remember reading that there was an easy way to select everything (select *) with the exception of one column - I dont want to have to list out all the field names because I want all except one column.

Does anyone know how to do this - I cannot remember.

Thanks!

Angela

 

[vongrunt]

Go to QA, find table in object browser (F8), right-click, script as SELECT, remove unwanted column.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SQLDenis]

Or
in QA navigate to the table click on the plus
drag the whole columns folder into the QA window and delete the one column that you don't want

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLSister]

Select * is a very poor programming practice. Especially id you use it for anything with a join (sends repeated unnneeded information which can contribute to performance problems) or as part of the select in an insert statement (what happens if somebody changes the column order in one of the tables or addsa field to one but not the other?

Never select more fields than you need. Using select * saves nothing but a couple of seconds at most. YOu can drag all the field names over from the object browser in almost the same time it takes to use select *. Using selet * is just lazy.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[ABerkowicz]

Thanks vongrunt for the information - this is not what I recall - I will have to look for what I was thinking about, but this did the job. Thanks!!!!!!!!

SQLSister - thanks for the information. In my case, I was appending to a specific table from backup where a customer messed up some records, so this was the simplist to do a select * to insert into an existing table that was in the same format.

So, while I agree with you that select * is usually not the best practice for joins and such - there are occasions where it is the best and quickest solution - as in my example...The reason I couldn't just use select * was because of an identity column that I needed to ignore and could not turn off in the live database.

Thanks everyone!