Selecting all but one column

Hi there all,

Wondered if anyone knew of an easy way of selecting all but one column from a table without specifying each column individually? I've got a table with around 50 columns and i need to create several views which pick up 49 of the columns and leave 1 behind - i'm loathing the prospect of having to manually specifying every column apart from the one i don't want!

Realistically, with a decent column-mode editor (Ultraedit on Windows, for example), this takes about 10 seconds per view.