• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2228
  • Last Modified:

Toad V7.3 sort tables alphabetically in schema browser window

Silly Question but I cannot figure this out.

I have TOAD v7.3.0.0 and in the schema browser when I select the tables tab the tables are not sorted alphabetically. How can I get the tables sorted.

thanks
0
chipbunker
Asked:
chipbunker
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
AFAIK, toad does sort automatically...
can you show the wrong "ordered" items?
0
 
sdstuberCommented:
click on the "Table" header in the schema browser.  Once to click ascending, once to click decending


or, you might have a filter/sort on it.  The little "sieve" icon, kind of looks like a V,  will bring up a filter/sort dialogue.  If you're forcing a sort through that, it will override the natural ascending/descending ordering
0
 
chipbunkerAuthor Commented:
Here is a picture of the schema
schema.jpg
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
chipbunkerAuthor Commented:
sdstuber

There are no filters and I am confused as to the tables "header" versus the tables tab?
0
 
sdstuberCommented:
oh, the left window in my Toad has a "Name" column with a header button. on it.  I have an newer version though.  I forgot the older version didn't have those.
Right click, in that window.  Does 7.3 have the custom query option?  Maybe you got one of those.
0
 
sdstuberCommented:
if you can't figure out where it got the data sorted like that, remember you can always ask toad to spool the sql to screen and see what queries it's running.  Maybe it's sorting as part of the query instead of inside the gui itself.
0
 
chipbunkerAuthor Commented:
sdstuber,
no custom query option.
0
 
chipbunkerAuthor Commented:
I spooled the sql and there is no sort on the query, is there a way to change the query that displays the schema browser. (I would think it is embedded in the toad code.)
0
 
DavidSenior Oracle Database AdministratorCommented:
Open Options, there is an attribute controlling the default display order -- as best as I recall.
0
 
DauheeCommented:
you should upgrade to the latest version - 9.6 currently. It definitely sorts the table list without you having to change any settings. Just download it from the quest website.

the upgrade is free for license holders and you will have access to a lot more features.
0
 
chipbunkerAuthor Commented:
doughee, that worked. The reason it was not sorted according to toad was that the DB was version 10.3 and toad 7.3 does not work correctly with that version. So I upgraded and everything is fine. you get the points because what you suggested is what I ended up doing.

thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now