Database Explorer
Use the Database Explorer to view details for database objects.
To open the Database Explorer
- Select
- The Database Explorer opens displaying details for the selected
- Select the Data tab to view data for tables and views. For additional information, see About Working with Data.
-
To view data and create queries for Google Analytics and SQL Server Analysis Services connections, see the following:
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.
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
-
To locate objects including procedures, functions, views, variable names and comments in an object's source code, use Object Search. Search for Objects
-
To use a different method to select objects such as tabs, drop-downs, or a tree view, click
.
-
To open the Background Processes window and cancel a query, click the progress bar located on the lower right side of the status bar.