DbSchema Database Designer

DbSchema Designer | Relational Data Editor

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.

DbSchema Features

DbSchema → Your Trusted Partner in Database Design

Simplify complex database workflows and improve productivity with DbSchema's advanced design and management tools

Visual Design & Modeling
Visual Design & Schema Layout

➤ Create and manage your database schema visually through a user-friendly graphical interface.

➤ Easily arrange tables, columns, and foreign keys to simplify complex database structures, ensuring clarity and accessibility.

GIT & Collaboration
Version Control & Collaboration

➤ Manage schema changes through version control with built-in Git integration, ensuring every update is tracked and backed up.

➤ Collaborate efficiently with your team to maintain data integrity and streamline your workflow for accurate, consistent results.

Data Explorer & Query Builder
Relational Data & Query Builder

➤ Seamlessly navigate and visually explore your database, inspecting tables and their relationships.

➤ Build complex SQL queries using an intuitive drag-and-drop interface, providing instant results for quick, actionable insights.

Interactive Documentation & Reporting
HTML5 Documentation & Reporting

➤ Generate HTML5 documentation that provides an interactive view of your database schema.

➤ Include comments for columns, use tags for better organization, and create visually reports.