Switch to: V9V8V7V6V5

Schema Editor - Tree View

A tree view presents a hierarchical view of information. Object can have sub-objects depending on if there is an association between the two; If an object can contain another object, then the parent item will either appear as or work similarly to a folder which you can expand or close.

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 a pane that displays the tree of all schema objects.

  • This tree can have few root objects that are connections to this or that data source.
    • 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.
  • Each database can have different elements as Tables, Links, Triggers, Stored Procedures, … Each group of such elements is displayed as a folder. In the parents after the folder name, you can see the number of elements inside.
  • Any object or group can be expanded/collapsed with all child items at once using the ALT/OPTION + left mouse button click on the disclosure icon [Valentina Studio Pro] (since v7.4.1)

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.