Toad Data Point 6.0.5 - Release Notes

Chat now with support

Use the Database Explorer to view details for database objects.

Click here to view a video of this feature.

To open the Database Explorer

Select Tools | Explorer.
The Database Explorer opens displaying details for the selected object.
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:
- Create Google Analytics Queries
- Create Queries for SQL Server Analysis Services

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

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. 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.