Relational Data Browse & Editor

Introduction

Relational Data Browse is a DbSchema tool used for exploring and editing data from one or multiple tables based on the foreign keys between them. If no foreign keys are defined, virtual foreign keys can be created in layout. Data Editor tool will open inside the layout and will be saved to model file.

How to Access the Relational Data Browse

  • From the menu
How to start Relational Data Browse from the DbSchema Menu
  • From the table header
Start Relational Data Browse by clicking the foreign key icon

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

Cascade into further tables

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 Browse

Insert or Edit Data Records

  • To insert data in the table, click on the insert button found in the footer of the table.
  • 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, simply click on the delete button.
Use Relational Data Browse to edit data

View or Upload Images and Blob Data

Relational Data Browse can be used for viewing images from 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 as Word, Excel, etc. as well. You have to enter the file extension under which the content will be saved. DbSchema will save it with a random name and the given extension, and will open the application which is registered in Windows as default application for this extension.