Switch to: V12V11V10V9V8V7V6V5

Schema Editor - Tree View

In the Tree View you browse a database schema using tree view. Each object that have elements is shown as a folder, which you can expand by mouse click to see elements inside of it. Each such folder displays the number of elements inside of it even when it is closed.

This style of view is good known for Windows users, which can see it in many applications starting from Windows Explorer with Folder View to be on.

Tree view on objects of database schema can be useful if you want, for example, find what table or field is the most heavy in database. Or compare flags for many fields of table, and so on. This is easy in this view, because you can see many objects and their properties in the same time.

Tree Pane

On the left side of Tree View you can see pane that displays the tree of all schema objects.

  • This tree can have few root objects that are connections to this or that datasource.
    • Bonjour Valentina Servers
    • Connections to other Valentina Server
    • Valentina Files
    • SQLite Files
  • Each connection can have few databases opened in the scope of this connection.
  • And, finally, each database can have different elements as Tables, Links, Triggers, Stored Procedures, … Each group of such elements is displayed as yellow folder. In the parents after the folder name you can see the number of elements inside.

Information Pane

In the middle top of window you can see Information Pane which displays different information depending on selected object(s) in the tree.

  • If a folder is selected - then info pane shows the list of all its items. For example, if you select folder Tables, then you will see the list of tables with their properties. See picture above as example.
  • If a single object is selected - then info page shows only one row for that object and its properties.

You can tune what properties to show for an object. For this do right click in the row of properties name and open dialog “Select Columns”.

Editor Pane

When you select a single object such as Table, Field, Link, Procedure, Trigger, … at the middle bottom you will see data from this object. For a Table this is records. For a Link this is two-columns table. For a field this records only for this column.

For most objects you can edit values right here.

Property Inspector

On the right side of Schema Editor in all three modes may present the Property Inspector. It displays properties of a selected object, so you can read them and edit.

Property Inspector can be hidden and shown from the application menu VIEW and using shortcut CMD + I.