DbSchema Diagrams

With DbSchema you will interact with the database using diagrams. ER diagrams are interactive - double click any table, column, foreign key to edit.

In DbSchema the diagrams are called layouts. You can create multiple layouts with the same or different tables. They will be saved to project file and can be later reopened.

ER Diagram

Or click here for a HTML5 documentation preview.

Edit Tables in Diagram

Double-click tables, columns or foreign keys to edit. Tables can be added to any layout by drag and drop. Create foreign keys by drag and drop of the referring column over the primary key column.

Virtual Foreign Keys

Virtual Foreign Keys are created only in DbSchema and saved to project file. Using them you can better describe the schema. They are used in Relational Data Browse for exploring data from multiple tables, in Query Builder for joins and for getting a better understanding of the schema.

Fast Preview Data

Click a table header with CTRL+SHIFT down to preview the database data. Get a better view by choosing 'Relational Data Browse Editor', with simultaneous view of data from multiple tables.

Multiple Layouts

For a better understanding of the schema you can create multiple layouts, each focused on a specific part of the schema. A table can show in one or more layouts.

Show Column Data Types

In the menu you have an option of showing the column data type directly in the diagram.

Foreign Key Drawing

Foreign keys can be drawn in two ways: point to the involved tables or to columns. When pointing to the columns the foreign key lines may share a single line.

Drag & Drop Tables

Add tables to layout by drag and drop them from Schema Structure or by pressing the foreign key arrow icon beside columns in the existing tables.

Printing

DbSchema prints the best quality layout images. Printing can be done as well to PDF or HTML5 small vector images.

HTML5 Documentation

From the menu generate the HTML5 diagram image. Table and column comments shows as tooltips. Click here to view a sample documentation.

Navigation