Relational Data Explorer & Editor

Introduction

The Relational Data Explorer 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 Explorer

From the menu

How to start Relational Data Explorer from the DbSchema Menu

From the table header

Start Relational Data Explorer by clicking the foreign key icon

Relational Data Explorer 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 Explorer

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.

Use Relational Data Explorer to edit data

View or Upload Images and Blob Data

Relational Data Explorer 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.