Chat now with support
Chat with Support

Toad Data Point 6.2.3 - User Guide

Database Explorer

Use the Database Explorer to view details for database objects.

Click here to view a video of this feature.

To open the Database Explorer

  1. Select  Tools | Explorer.
  2. The Database Explorer opens displaying details for the selected object.
  3. Select the Data tab to view data for tables and views. For additional information, see About Working with Data.
  4. 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

  1. Select Tools | Options.
  2. 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 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 open the Background Processes window and cancel a query, click the progress bar located on the lower right side of the status bar.

  

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating