[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2210
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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