Relational Data Editor & Editor

Introduction

The Relational Data Editor is a DbSchema tool for visualizing and editing data from multiple tables based on the foreign keys. If no foreign keys are defined, create virtual foreign keys in the layout. The Data Explorer will open inside the layout and will be saved to the model file.

How to Access the Relational Data Editor

From the menu

How to start Relational Data Editor from the DbSchema Menu

From the table header

Start Relational Data Editor by clicking the foreign key icon

Relational Data Editor will open on the Tools bottom part of your screen. To descend into further tables, press the foreign key button found on the table header.

You can cascade an unlimited number of tables. Selecting a different row in one of the windows will update the child tables with the records matching the foreign key.

Filter Data

Filter data from one of the windows by creating a data filter. Click the column header to create the filter.

Setup filters in the Relational Data Editor

Insert or Edit Data Records

To insert data in the table, click on the insert button in the table footer.
To edit data in the table, click on the edit button. You can also edit data by double-clicking on the cell.
To remove any data from the table, click on the delete button.

View or Upload Images and Blob Data

Relational Data Editor is used for viewing images from the database, blob data, etc. Right-click the column in the browse scene and choose the option to view data. You can view data using external applications like Word, Excel, etc. as well. You have to enter the file extension to save the content. The correct extension will open the application registered in Windows as the default application for this extension.

Dropping Data Explorers

The Data Explorer editor can be dropped by right-clicking the editor in the structure tree, under the 'Layouts'.

When closing an Data Explorer editor, DbSchema will ask if you wish to preserve the editor in the design model ( close the editor but keep a copy in the design model, so it can be reopen at any time ), or close and drop from the design model as well.