Database menu

The icon, menu name, shortcut key, and description of each option in the Database menu.

Table 1. The Database menu
Icon Menu Item Accelerator (Shortcut) Description
  Database    

icon
  Extract Schema... Ctrl+M Extract schema from database.

icon
  Import SCH File...   Import schema from sch file.

icon
  Update Schema   Update database meta-schema file from database. See Update a meta-schema from database.

icon
  Generate SCH File   Generate a BDL schema file (sch) from the meta-schema file. This file is automatically created by Genero Studio when a meta-schema is compiled. See BDL schema file (sch).

icon
  Generate Database Creation Script   Used to generate a source 4gl file that can be used to create a new database and tables according to the meta-schema file See Generate a database script from meta-schema.

icon
  Generate Database Update Script   Used to generate a source 4gl file that can be used to update an existing database based on the meta-schema file. See Generate a database script from meta-schema.

icon
  Generate Schema Documentation   Generates an HTML page with details on the meta-schema. See Generate meta-schema documentation.

icon
  Diff Schema...   See Comparing two meta-schemas.

icon
  Add Table   See Add new tables and columns.

icon
  Add Column   See Add new tables and columns.

icon
  Add Constraint or Index   See Add constraints or indexes.

icon
  Add Foreign Key   See Add foreign keys.

icon
  Select Esc Selection tool.

icon
  Edit F2 Edit properties of the item selected.

icon
  Insert Column Before Ctrl+Shift+Ins See Add new tables and columns.

icon
  Insert Column After Ins See Add new tables and columns.

icon
  Revert   See Revert schema changes dialog.
    Layout   Rearrange the items in the diagram.
    Filter Items   The Filter View dialog allows you to hide and show items on a diagram.
    Locate in Diagram   This action brings focus in the diagram to the selected item. If the selected object is not visible in the current view, the Meta-schema Manager will try to find another view where the object is visible. If no view is found, you are prompted to make the object visible in the current view or to create a new view.

icon
  Advanced Properties   Specify the extraction and/or generation options. See Extract meta-schema information from database and Generate a database script from meta-schema.