Toad World® Forums

Schema Table Folder Structure

Hi all,

I'm new to Toad for SQL Server and was wondering if there was a way to configure TOAD to group tables by schema so that it can collapse and expand depending on which schema and associated tables you want to see.

So for example if I had 3 different schemas in the database I would like for the Object Explorer to look something like this.

Schema1
- schema1.table1
- schema1.table2
- schema1.table3
Schema2
- schema2.table1
- schema2.table2
- schema2.table3
Schema3
- schema3.table1
- schema3.table2
- schema3.table3

Any help would be appreciated

Thanks
Jack

Not aware that Toad can do exactly as you've outlined, but might be able to get you close.. essentially by checking a box in Options, then showing the schema name in the Object Explorer.

1 Like

Thanks for the info and detail screen shot. One follow up question when I create filters, is it possible to multi select saved filters?

Thanks for the info and detail screen shot. One follow up question when I create filters, is it possible to multi select saved filters?

Ah, not that I can see, but what a great enhancement suggestion, especially if you have many schemas. Work-around for now is that you will need to define your "multi-schema" filters with custom SQL.... e.g.