Database Explorer

Use the Database Explorer to view database objects across multiple databases or servers. The Database Explorer contains the following panes:

Object List pane (left side)—Displays the object types available. The available object types vary based on the database version you are using.

Object Details pane (right side)—Displays drill-down information for the object selected in the Objects pane.

Troubleshooting: If you cannot see all your schemas or objects in the list, make certain that any filters are cleared.

To open the Database Explorer

Select Tools | Database Explorer.
The Database Explorer opens displaying details for the selected database.
Select an object in the left pane to display details in the right pane.

You can select another schema to view, or you can filter the list of objects. Review the following for additional information:

Schema (first field)

Select the schema you want to view. You can filter the list of schemas that display. See Filter Databases and Objects for more information.

Object Filter (second field)

You can quickly set a filter in this field. To do so, enter a name or partial name of an object and press ENTER. Any advanced object filters you set display in this field.

You can also perform advanced filtering based on case sensitivity, statistics, or other options. See Filter Databases and Objects for more information.

Tip: You can enable an option to filter using regular expressions in Tools | Options | Explorer | General.

Configure Database Explorer Options

You can specify options for the look and behavior of the Database Explorer by using the Toad Options dialog.

To configure Database Explorer options

Select Tools | Options.

To specify one of the following options, select the corresponding page in the Options dialog.

Option Description	Page in Options Dialog
Group object types into logical categories that can be sorted or hidden; or change the caption that displays for object types.	Select Explorer \| General
Limit the number of rows initially returned when retrieving data	Select Database \| General
Automatically commit changes after every update.	Select Database \| General
Hide system objects (SQL Server).	Select Database \| SQL Server

Tips:

To navigate to a previously selected object or tab, click . You can also click to move to the next selected object or tab.
To view objects that the selected object uses or that reference the selected object, use the Uses or Used By tabs.
To locate objects including procedures, functions, views, variable names and comments in an object's source code, use Object Search. See Search for Objects for more information.
To use a different method to select objects such as tabs, drop-downs, or a tree view, click .
To generate reports, export data, create SQL statements, version control objects, or send objects to the Project Manager, SQL Modeler, or Master Detail windows, right-click the objects and select an option.
To open the Background Processes window and cancel a query, click the progress bar located on the lower right side of the status bar.