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.
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.
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.