Thanks guys, First off, I’m disgustingly lazy.
I could use the “show/hide” columns as Rich suggested but here is my typical
I want to examine a table which say has 20-30 columns. Some of the columns will
contain meaningful data but lots of the columns will be full of legacy crap. The
problem is, I don’t know the crap columns until I am actually looking at the
I do a SELECT * FROM MYTABLE
and start to examine the data in the data grid. Obviously, with say 25 columns,
many of them will be off the right hand side of the screen and I will have to
grab the left/right scroll bar.As I scroll to the right, my eyes are on the data
in the center of the screen. Now say I see a column with crap data. In order to
use the “show/hide” drop-down I have to move my eyes away from the column I am
currently examining and and find the little show/hide icon on the left. Then I
need to move my mouse cursor over and hit that very tiny icon. Then I need to
find the name of column (many columns are very close spellings, so I might need
to dart my eyes back and see if I got the spelling right), then I need to click
the little box next to the column I want to remove. Then Mouse back over to the
scroll bar etc etc, and repeat this process as I encounter columns I want to
The old way, move cursor up, grab the column name and drop it anywhere on the
data grid. Eyes stay focused in same location and mouse cursor does minimal
movement and I don’t even need to read the column name.
Bert, yes, tried ABOVE, being careful not to drop the column name into the
‘group by’ section. Same result, after drop, column is still there.
On Thu, Jun 2, 2011 at 9:59 AM, Bert Scalzo wrote:
Did you try above or up instead of below or down ???