View Database Data


DbWrench's Table Data Viewer can be used to view the data in database tables without having to use SQL.

To use Table Data Viewer a database must be open in DbWrench and a Connection must be defined for that database server.

Note: The Connection combo box in Table Data Viewer will only show connections that match the current DbWrench database.

Here is an example of Table Data Viewer.


Table Data Viewer for the table 'Invoice' on the database server 'localhost'.

View Data for a Table

From the Tools menu, click Table Data Viewer. This item will be disabled if no database is currently open in DbWrench.

In Table Data Viewer select the Connection for the server to use.

Click Add Data View, this will bring up a dialog with a combo box. From the combo box select the table to view data from.

A tab with data for that table will now be displayed.

Add Data View can be used to view data from more tables.

Data in the grid can be sorted by clicking on the table headers. It can be sorted by multiple columns if the 'ctrl' key is held down while the column headers are clicked.


See also:

Create a Connection
Modify Database Data