Relational Data Browse & Editor


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


Access Relational Data Browse

  • From the menu
Create from Menu
  • From the table header
Create from Header

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.

Descend

Filter Data

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

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