You can set the Schema Browser to automatically refresh the data grid while you are working with a specific object. This setting only lasts for your active dataset, and turns itself off if you select another object or close the Schema Browser.
To automatically refresh the data grid
Select Auto Refresh in the Data tab toolbar (right-hand side of the Schema Browser).
Object filters reduce the number of objects displayed in a schema.
To create browser filters
-
Depending on the Schema Browser style you have selected (tabbed or dropdown vs. treeview) do one of the following:
Tabbed or dropdown: Select the object type that you want to filter, for example Tables or Roles, and then click on the Schema Browser toolbar.
Tree view: Right click the object type in the tree view, then select Filter object_type.
- Complete the fields as necessary.
- To save the filter, click Saved Filters and select Save Current Filter As.
- 'Save filter data for all object types,' or
- 'Save filter data for roles only' (in this example).
Saves into an SBFLT file. When such a file is reloaded, current settings for other object types are not changed.
-
To customize or review the query before applying it, select View/Edit Query Before Executing and click OK.
Notes:
- Do not change the SELECT list.
- When entering the IN clause, you must enclose the table name in single quotes ('TEST'). This lets you enter multiple table names ( such as 'TABLE1', 'TABLE2', 'TABLE3') or enter a sub-query.
You can create a default filter for each object type, which is used for all schemas.
Notes:
- Instead of using the same default filter for each object type, you can have Toad automatically save filters per connection or schema name.
- This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create default filters
- Select Session | Schema Browser Filters.
-
Select an object type on the left and set the filter options. Create Schema Browser Filters
Note: When you click OK, Toad saves default filters in a file named Toad_DEF.SBFLT in the User Files folder.