Is there a way to show schemas in the object browser?
Right now, I see the databases then tables, but I don't see schemas.
Welcome to the TDP forum on ToadWorld!
You should be able to see the schema name associated with your tables in the Object Explorer, per snap below...
Thank you for the response. I do see that, but is there a way to show the unique list of schemas then expand the ones I'm interested in? I'm working on a database that has thousands of tables and it's not easy to navigate this way.
Toad for Oracle does that perfectly.
Agree that Toad for Oracle does that nicely in that the Schema Browser has this built-in.
It would be nice to add an extra column to TDP's Object Explorer to indicate Schema name for SnowFlake tables, as can be done for some other data sources like SQL Server (e.g. right-click column header in Object Explorer and choose Options->Extra Columns).
However, I have an idea for a work-around involving filters that you might like. Simply define filter/s that only display objects with the desired schema name. See snaps below on how to do it. Hope this helps.
Which version of tdp do you use?