Data Port Console

Getting Started Tutorial: Using diagrams

Database diagrams graphically depict the relationships between tables as defined by the FOREIGN KEY constraints. Data Port Console allows you to create multiple database diagrams per database, and exposes all database editing features right from the diagram view, so you can create new tables, view and edit data, add or remove constraints, and so forth.

Creating a diagram
Database diagrams are created under the Diagrams folder of the database in the Data Explorer pane. To create your first diagram, right-click the Diagrams folder:

A new empty Diagram view will be diaplayed in the tabbed area ready to start creating a new diagram:

You can start populating the diagram either by selecting from the list of existing tables or by creating a new table. To select an existing table, right-click the diagram and select the Add Table menu option:

This brings up the list of tables that are not yet present in the current diagram. Because you are creating a new diagram, all tables will be present:

You can select all tables by checking the lower check box. When all the tables you want to display on the diagram are selected you can press the OK button and see the resulting diagram. In this sample case if you select all tables, the displayed diagram will look like this:

The table boxes can be repositioned and resized like a regular window. Links between the tables represent the foreign key relations and are automatically drawn an layed out according to the relative position between the two tables. The key symbol represents the primary key side of the relation. After a brief rearrangement of the tables, we can get a much nicer layout:

Previous: Executing SQL queries