Structure Editor

Design and model the architecture of your database with ease using the 4D Structure Editor.

Just one click

With just one mouse click and the Properties inspector, you can add tables, fields, relations, and change settings on the fly.

Always-on validation

Our new SQL syntax check dynamically validates tables and fields as you work, so you always know that your structure is SQL-compatible.

Easy on the eyes

• Overview of the Structure Editor

The Structure Editor has a number of tools to help you organize your application code for better readability,. For example, the cardinality of relations are displayed clearly (0<minimum > 1, 1<maximum > n) to avoid any confusion when reading.

Some of our other editing tools include:

Zoom: In the blink of an eye, you can see your complete structure or drill down to focus on a specific element.
Alignment: You can optimize the location and the size of tables for better visual clarity.
Field Sort: You have multiple options for sorting field order.
Color coding for tables, fields, and indexes.

Application analysis

There are a number of features available within the structure editor to help you during application analysis. For example, when you're working on a complex structure, you can choose to hide parts in order to focus on the remaining elements without distraction.

Clear organization

Using group management, you can organize a database structure by feature. This makes it easy to hide tables that don’t belong to the feature that you want to analyze.

<< Explorer

Back to the feature list

Index Explorer >>