Toad World® Forums

Filter in Object Explorer by schema

I would like to filter what Tables I see in the Object Explorer by their schema. The Table filter options will filter on the table name, but not on schema name.

What I’ve read seems to suggest the key to the filtering is all based on a view referred to on the SQL tab of the filter as ‘obj’, but I cannot find any definition for this.

How can I do this? Thanks.

When you define the filter use the Owner category to filter by schema…

Ah. Yes. That does it. Didn’t realise that you could enter a value there. Thanks!

If I want to see just the table names, regardless of schema how would I do that? I use to use Hyperion and the default was table names only, and if you wanted full name you could toggle on the schema name on/off.