Generate a database script from meta-schema

Generate a 4gl source file to be used to create or update a database that is described in the meta-schema file.

1. Right-click on the meta-schema file in the project.
2. Select an option:
   • Generate Database Creation Script to generate a source 4gl file that can be used to create a new database and tables according to the meta-schema file.
   • Generate Database Update Script to generate a source 4gl file that can be used to update an existing database based on the meta-schema file.
     Note: The database update script will first drop the existing tables including their data, and then recreate the structure of the database based on the modified schema. Previous versions of the tables will be backed up and the data will be migrated to the new tables when applicable. It is recommended to perform a backup of the database prior to running the update script.
3. Complete the Generate Database Script dialog and select Generate.