Filtering Schema Browser Schemas

It’s not unusual for a typical database to have lots of schemas. In fact, many of today’s database applications routinely create a schema per application user. These user schemas often possess no database objects, but instead access the central application tables by using grants and synonyms. When you’re working within TOAD’s Schema Browser, these user schemas are really of limited value. Thus you would like to see them filtered out of the drop-down list in the Schema Browser for the schema to focus upon (because they have no objects and will never really display anything). As with everywhere else in TOAD, there is an option to control this and it’s simple to do.

Figure 2.10 shows the TOAD Schema Browser drop-down ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.