Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Browse Data in Related Tables

Browse Data in Related Tables

Use the Master Detail Browser to browse data in parent tables and drill-down to data in related child tables. This is useful when you need to analyze or edit data. For example, suppose you need to view a list of all Nick's Flix stores and the inventory of comedy movies at each store. Using the Master Detail Browser, you specify the table that contains the list of stores as the parent table and specify the table that contains comedy movies as the child table to quickly locate comedies and analyze the inventory.

To browse tables using the Master Detail Browser

  1. Select Tools | Master Detail Browser (ALT+T+A).

  2. Drag one or more tables from the Object Explorer, Object Search, or Project Manager window to the Diagram pane at the top of the Master Detail Browser. Press CTRL+click to select multiple tables at once.

    Notes:

  3. Join Columns

  4. Select the checkbox beside each column you want to include.

    Note: Any columns included in a join are automatically included in the results.

  5. Click (F9) to retrieve data for the parent table initially. To view data in a child table, click + to the left of each row.

    or

    Click to retrieve data in the parent and child tables. If there is more than one child table, a tab displays for each child table.

  6. From the data grid, you can:

Tips: