Switch to: V10V9V8V7V6V5

Contextual Menu - Table

Contextual Menu - Table

For a table, the Tool- or Context Menu provides the following tools:

  • Open Data Editor – Opens a Data Browser window for the selected table, allowing you to e.g. define new records.
  • Design Table – Opens the dialog for changing structure of the table.
  • Diagnose – Opens the Diagnose dialog for requesting a diagnose of the state of the table and its elements. The latest diagnose given is always saved in the directory of the diagnosed database. This file will be overwritten when another diagnose is requested. There is an option to request an additional output in a text window.
  • Reindex Table – Forces the creation of new indexes for the selected table.
  • Encrypt – Opens the Encrypt dialog for encrypting the selected table. Valentina uses the Blowfish encryption algorithm by default.
  • Export to CSV – Opens the Export dialog for importing data.
  • Import from CSV – Opens the Import Wizard for importing data.
  • Create Dump – Allows you to generate dumps of several kinds:
    • XML – Generates an XML dump of the selected table (e.g. for backup reasons).
    • SQL – Generates an SQL dump of the selected table (e.g. for backup reasons).
  • Load Dump – Allows you to load dumps of several kinds:
    • XML – Opens a system window that will allow you to load an XML-Dump.
    • SQL – Opens a system window that will allow you to load an SQL-Dump.
  • Statistics – Shows the statistical information about the table.
  • Delete – Drops the table from the schema.
  • Refresh – Updates properties and children of the table.

Submenu Create

Submenu Create

  • Create Check – Opens the Design Table dialog on the Check Tab for creating a new check.
  • Create Field – Opens the Design Table dialog on the Field Tab for creating a new field.
  • Create Index – Opens the Design Table dialog on the Index Tab for creating a new index.
  • Create Link – Opens the Create Link dialog for creating a new link.
  • Create Method – Opens the Design Table dialog on the Method Tab for creating a new method.
  • Create Property – Opens the Design Table dialog on the Property Tab for creating a new property.
  • Create Trigger – Opens the Design Table dialog on the Trigger Tab for creating a new trigger.
  • Create Unique – Opens the Design Table dialog on the Unique Tab for creating a new unique.