Toad World® Forums

Column ID


#1

There are times when I’m searching for a column of data in a table that
may have 50 or maybe 100 columns. In the Describe Columns tab I can easily
alphabetize the names and find the one I’m looking for.

Not quite so easy in the Describe Data tab. So far as I know, the header row
displays the column names in the order they’re defined in the db. And
that’s the way I’d prefer to see them.

What I’m wondering is if there is a way in Toad 9.7 to get a second header
row with the Column ID. Having ascertained same from the Columns tab I could
easily scroll over to that column instead of trying to read each column name.

Thanks much,

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323

image001.jpeg


#2

Hi Dan,

There’s no way to do that in 9.7.

How about this though – rt-click -> Select columns, click
“Unselect all”, check a few so you can identify the row, then type
in the name of the column you’re looking for, and check it. Then the grid
will be down to a few columns.

-John
image001.jpeg


#3

I could make that work; just have to pick the right columns to go with the one I
want.

Thanks much,

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg