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
Import MS XML Schema... Import schema from MSXML file. For more information, go to Creating a report using an MSXML schema 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 tables and columns to a database meta-schema.

icon
Add Column See Add tables and columns to a database meta-schema.

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 tables and columns to a database meta-schema.

icon
Insert Column After Ins See Add tables and columns to a database meta-schema.

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 a meta-schema information from a database and Generate a database script from meta-schema.