# simple question re data grid columns

**URL:** <https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 2, 2011, 11:42am UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488 "2011-06-02T11:42:19Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![michaeljmooregmail.c](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaeljmooregmail.c/32/12432_2.png) [@michaeljmooregmail.c](https://forums.toadworld.com/u/michaeljmooregmail.c)\
**Post date:** [June 2, 2011, 11:42am UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/1 "2011-06-02T11:42:19Z")

</div>

In V9 (I think) you could grab the column header in the data grid and drag it  
downward to where the data is showing and drop it. This would cause the entire  
column to disappear (be hidden). In V10 it does not seem to work this way. You  
drop the column header and nothing happens.

Is there a parameter that can restore the old functionality or is there a way I  
can drop column in the data grid without leaving the data grid window?

Thanks,  
Mike

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [June 2, 2011, 11:59am UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/2 "2011-06-02T11:59:25Z")

</div>

Did you try above or up instead of below or down ???

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [June 2, 2011, 11:59am UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/3 "2011-06-02T11:59:50Z")

</div>

Hey Mike,

> In V9 (I think) you could grab the column header in the data grid and drag  
> it downward to where the data is showing and drop it. This would cause the  
> entire column to disappear (be hidden). In V10 it does not seem to work this  
> way. You drop the column header and nothing happens.
> 
> Is there a parameter that can restore the old functionality or is there a  
> way I can drop column in the data grid without leaving the data grid window?

Do you mean the little icon in the header bar all the way to the left of the  
first column? It looks like a paragraph thingy and it'll allow you to  
select which columns are visible.

Rich -- [TeamT]

Disclaimer: Schoooooooooooool's out for summer!

---

<div class="post-metadata">

**Author:** ![michaeljmooregmail.c](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaeljmooregmail.c/32/12432_2.png) [@michaeljmooregmail.c](https://forums.toadworld.com/u/michaeljmooregmail.c)\
**Post date:** [June 2, 2011, 12:27pm UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/4 "2011-06-02T12:27:53Z")

</div>

Thanks guys, First off, I’m disgustingly lazy.

I could use the “show/hide” columns as Rich suggested but here is my typical  
thought process.  
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  
data. So,  
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  
remove.

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.

Regards,  
Mike

On Thu, Jun 2, 2011 at 9:59 AM, Bert Scalzo wrote:

```
Did you try above or up instead of below or down ???
```

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [June 2, 2011, 12:35pm UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/5 "2011-06-02T12:35:54Z")

</div>

Aha – my bad – I thought you meant you wanted the group by –  
sorry to steer ya wrong J

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [June 2, 2011, 12:44pm UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/6 "2011-06-02T12:44:32Z")

</div>

> In V10 it does not seem to work this way

I see this in 10.5 and 10.6, but not in Toad 11 beta. Unless there's an option  
controlling it that I'm not seeing, this is fixed.

---

<div class="post-metadata">

**Author:** ![michaeljmooregmail.c](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaeljmooregmail.c/32/12432_2.png) [@michaeljmooregmail.c](https://forums.toadworld.com/u/michaeljmooregmail.c)\
**Post date:** [June 2, 2011, 1:02pm UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/7 "2011-06-02T13:02:31Z")

</div>

So Michael, you are saying you see ‘the problem’ in 10.5 and 10.6, but  
it appears to be working correctly in 11?  
I’m running 10.6.

Glad to hear it works in 11 beta. It’s a feature I like.

Regards,  
Mike

On Thu, Jun 2, 2011 at 10:44 AM, Michael Staszewski \<  
[michael.staszewski@quest.com](mailto:michael.staszewski@quest.com) \> wrote:

```
> In V10 it does not seem to work this way

 

I see this in 10.5 and 10.6, but not in Toad 11 beta. Unless there's an
option controlling it that I'm not seeing, this is fixed.
```

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [June 2, 2011, 1:07pm UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/8 "2011-06-02T13:07:52Z")

</div>

> you are saying you see 'the problem' in 10.5 and 10.6, but it appears to be  
> working correctly in 11?

Exactly.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 2, 2011, 1:34pm UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/9 "2011-06-02T13:34:42Z")

</div>

It’s not an option. I added it to the beta.

---

<div class="post-metadata">

**Author:** ![michaeljmooregmail.c](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/michaeljmooregmail.c/32/12432_2.png) [@michaeljmooregmail.c](https://forums.toadworld.com/u/michaeljmooregmail.c)\
**Post date:** [June 2, 2011, 1:35pm UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/10 "2011-06-02T13:35:58Z")

</div>

cool, okay, thanks John.

On Thu, Jun 2, 2011 at 11:34 AM, John Dorlon wrote:

```
It’s not an option. I added it to the beta.
```

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [June 3, 2011, 7:45am UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/11 "2011-06-03T07:45:50Z")

</div>

Pure awesomeness.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 3, 2011, 7:51am UTC](https://forums.toadworld.com/t/simple-question-re-data-grid-columns/10488/12 "2011-06-03T07:51:30Z")

</div>

in sauce form.
