DbSchema Database Designer

DbSchema Designer | Relational Data Editor

Publish on DbSchema Blog >>>

Relational databases are used when a project store structured data and has a fixed schema.
They can handle a lot of complex queries, database transactions and routine analysis of data. Relational databases make
data browsing very accessible, but even so, they still require complex SQL Queries. This can be time-consuming, especially
for a beginner in SQL syntax.

Relational Data Editor, an editor integrated by DbSchema, is an optimal solution to this problem. In this tutorial,
we’ll go over the functionality of this feature.

Access Relational Data Editor

Relational Data Editor is a tool inside DbSchema, that allows users to explore and edit queries visually.
This makes it very easy to search for data without having to write complex SQL queries.

To access Relational Data Editor in DbSchema, right-click on the table header,
and choose the tool from the menu. In the lower half of the screen, a new Relational Data Editor tab will open.

Open Relational Data Editor

Create Foreign Keys & Virtual Foreign Keys

A foreign key is a constraint enfoced on columns or group of columns in a relational database table that provides a link between data in two
tables. The foreign key acts like a cross-reference between the two tables, because it references the primary key of another table.

Create foreign keys by drag & dropping a column from one table to another.

You can create a virtual foreign key. This is a foreign key stored only in DbSchema.
This option can be very helpful when the database you are trying to browse lacks foreign keys.

Descend Into Further Tables

By pressing the “foreign key” icon from the table header, you can open the child tables.
The number of tables that you can open in Relational Data Editor is unlimited.

When browsing a table, child tables will show only matching records to the parent table via a foreign key.

Edit table records

The tool allows you to easily edit any cell in the table by simply double-clicking on it.
You can also insert or delete data by using the two options found at the left-bottom of the table.

Add & view multimedia files

With relational data editor you can easily add and view blob or clob data type:

This feature makes browsing in relational databases very accessible and efficient.
If you want to remain hands-on SQL language, DbSchema allows you to write queries in SQL Editor. More on the SQL Editor in a next tutorial.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.