You can filter the list of database objects displayed in the Object Browser to only objects that you want by creating entity filters. For example, you can create a filter for object names that begin with "SALES" to have only tables and views with matching names displayed in the Object Browser.
To apply a filter to the Object Browser automatically each time you connect to the target database, you can mark the filter as default.
To create an entity filter:
To mark the filter as default, select the Is Default check box.
The specified filters are displayed in the Filters area of the Manage Schema Filters window.
Now, the created filter needs to be applied to the Object Browser.
You can apply a created filter to the Object Browser to display only those objects whose schemas and/or names meet the filtering criteria.
You don't need to apply the default filter; it will be applied automatically each time you connect to the target database.
To apply a created filter to the Object Browser:
Click View, point to Entity Filter, click Select, and then select the created filter.
Using entity filters in combination with turned-off schema groupings in the Object Browser (on the View menu, clear Group by Schema) will help you get to the objects you need more quickly.
To remove a filter from the Object Browser to display all database objects, on the View menu, point to Entity Filter and then click None.
You can remove the default filter for a currently open Query Analyzer window, but it will be reapplied in each new Query Analyzer window. You can turn off the default filter altogether.