Observe data with Master-Detail Browser

To open the Browser, go to the Database menu and click Master-Detail Browser. Alternately, right-click the required database objects in the Database Explorer window, select Send to, and click Master-Detail Browser.

Master-Detail Browser, available in dbForge Studio for MySQL, is a handy tool for viewing and analysis of related data in:

Parent tables or views
Related child tables or views
Self-referencing tables

A separate master-detail document with the *.mdet extension is created once you open the Master-Detail Browser.

Working in Design View

If you take a look at the screen of dbForge Studio, on the left you will see a MySQL explorer window (Database Explorer), from which you can drag tables and views onto your diagrams.

Arrows between tables or views show existing relations between them. Besides, you can create links between columns yourself. To create a link, just drag a column from one object to a column in the other object that you want to link. Right-click the link to change its direction or to remove it completely.

Master-Detail Browser for MySQL: Working in Design View

Working in Data View

Switch to the Data tab to observe the data.

If you want to view data according to certain criteria, write the WHERE condition in the corresponding field under the diagram. In this case, only the data that meets these criteria will be displayed.

If a table contains large amounts of data and you do not need to view all of them, you can set a fetch limit in the corresponding field under the diagram. The amount of memory, required to display the results, will be reduced.

To return to the Design View, switch to the Design tab.

Master-Detail Browser for MySQL: Working in Data View

Sorting Data in Master-Detail Browser

Click the required column header to sort data by a particular column, change the sorting direction, or stop sorting. Every subsequent click changes the sorting operation.

Master-Detail Browser for MySQL: Sorting Data

Filtering Data in Master-Detail Browser

Filtering allows you to display a subset of records in the table that meet a particular criterion. When filtering is applied to a table, the displayed records are restricted to those that meet the current filtering criterion. In order to filter data against single or multiple columns, select a column value from the filter drop-down list. You can choose a suggested filter or customize your own one using the Custom AutoFilter window.

Master-Detail Browser for MySQL: Filtering Data

Your ultimate MySQL browser

Gain all the advantages of Master-Detail Browser, where all of your data can be conveniently visualized in its entirety with Design and Data application views. This feature is available in the following editions of dbForge Studio for MySQL. You can also check our Master-Detail Browser documentation to get acquainted with the workflow.

Availability in the editions of dbForge Studio for MySQL

Feature

Enterprise

Professional

Standard

Express

Master-Detail Browser