Step 2: Display Database Diagrams in DbXaminer

Workshop's DbXaminer renders database diagrams.

DbXaminer is a tool that:

• renders the database diagram for a specific schema, table, or column
• maps out the relationships between the tables, the primary keys, and foreign keys

Examine the relationship between database tables

1. In DbXplorer, right-click the schema SalesDBConnection and select Show in DbXaminer

   

2. DbXaminer renders the database diagram for the selected schema. It displays a list of tables along with columns of the table. DbXaminer also renders the relationship between database tables. The relevant properties of each selected artifact are displayed in the Properties view. To move the focus of the database diagram to a different table or column simply click on it.

   
   
   You can also click on a schema, table or column in the DbXplorer view to change the diagram focus.
   
   If you right click on a schema, table or column in the DbXplorer view and choose Show in DbXaminer, then the diagram is redrawn to center on the selected element.

3. When you run the mouse over database components, DbXaminer displays the properties of that database component as a tool-tip.

   

4. You can perform also various operations like Zoom In, Zoom Out, and Auto Arrange by right clicking on a blank area of the diagram.

View data for a table or column

1. To view the data for a table or column, select a specific component and click the (Show Data) button in the toolbar of DbXaminer.
   
   For example, select the PRODUCT table by clicking on the table name. The table will be outlined to show that it is selected.
   Next click on the button.

   

2. Workshop generates the appropriate SQL query and displays the results. Note that this operation automatically switches to the SQL Editor tab (and out of the Diagram tab). The tabs are located at the bottom of the DbXaminer view.

   

3. You can sort the data by clicking the column name.

   

4. Similarly, to view data of a specific column of a table, click on the Diagram tab, select a column of the table and click the Show Data button.

   

Click one of the following arrows to navigate through the tutorial: