Toad World® Forums

SQL Navigator - can't see all schemas



I use SQL Navigator 7.1. When I logged in as user x, a automatic trigger set my default schema to y. After this I cant see my owen schema x in the db explorer. I see only the schema sys, dbsnmp.

What’s wrong.




Hi Roger,

it is strange, did you have any other special setting or trigger objects ?

If not, Could you pls send us your support bundle file from Help Menu->Create Support Bundle Files?


you can have a try to clean up your user profile and start again, follow these steps:

  1. close SQL Navigator

  2. rename registry key “HKEY_CURRENT_USER\Software\Quest Software\SQL Navigator 7.1.0” to " SQL Navigator 7.1.0bak"

  3. rename folder “%appdata%\Quest Software\SQL Navigator 7.1.0” to “SQL Navigator 7.1.0bak”

  4. now start up SQL Navigator again

  5. Please make sure “Cancel” is selected when SQL Navigator prompts the import profile settings dialog

Starting with fresh settings. If this doesn’t help, please send us or attach your support bundle file.