Switch to: V9V8V7V6V5

TIP: HOW TO change sort order of fields?

Valentina studio provides all schema objects in alphabetical order. To see the list of FIELDS in the native order you should change the appropriate property for the Schema Editor:

All changes in the Schema Editor will be applied only to the particular list during the current session. To change the sort order for all fields lists permanently you should use Preferences Dialog

Schema Editor

Depending on the Schema Editor view you have different options to change the fields sort order.

Toolbar (Columns View)

To change the sort order of the particular fields list in the Columns View, you should:

  • Select on of the fields in the list.
  • Press the toggle button Sort List in the Tool Bar.

Property Inspector (Tree View)

To change the sort order of the particular fields list in the Tree View, you should:

  • Select the fields list in the tree.
    • Change property Sort Items in the Property Inspector
    • Press the toggle button Sort List in the Tool Bar.

Contextual Menu (Tree View)

To change the sort order of the particular fields list in the Tree View, you should:

  • Select the fields list in the tree.
  • Select Sort List from the context menu

Diagram Editor

To change the sort order of the particular fields list in the Diagram Editor, you should:

  • Select the particular table on the diagram.
  • Open tab Properties in the Properties editor.
  • Change property sort_fields of the object.

Preferences Dialog

To change the global setting for sorting the fields list of all tables in the Schema editor, you should to:

  • Open Preferences Dialog.
  • Go to the EditorsSchema Editor .
  • Change setting Sort Fields.

This change will be applied to the all fields list in all databases.