Generate Database Script dialog

This allows you to specify various options for generating a database for your application.

It can be accessed via the application menu Project -> Generate Database or from the toolbar in the Generate Database tab.

Here is an example of what it looks like:

Available

This list displays those entities that will not be included when generating the database script. Double clicking an entity in the list will move it to the Selected list.

Add

This moves the selected entity in the Available list to the Selected list.

Add All

This moves the all entities in the Available list to the Selected list.

Selected List

This list displays those entities that will be included when generating the database script. Double clicking an entity in the list will move it to the Available list.

Remove

This moves the selected entity in the Selected list to the Available list.

Remove All

This moves the all entities in the Selected list to the Available list.

Database

This allows you to specify the type of Relational Database Management System (RDBMS) that you will be creating the database in. If your RDBMS is not listed then you try using the Generic option, or you can create your own database template.

Create tables

Whether to generate sql that creates tables for the selected entities.

Constraints

Whether to generate sql that creates the necessary table constraints for the selected entities.

Test records

Whether to generate sql that creates test records for the selected entities.

Support tables

Whether to generate sql that creates any necessary supporting tables for the application.

Drop/delete statements

Whether to generate drop and/or delete sql statements for the previous options. For example, if you have previously created the database tables you should select this option in addition to the Create tables option. This will ensure that the tables are dropped before they are created again.

Generate

This generates the database script for the selected options. The generated script is sent to the Execute Sql tab.

Related concepts

Test records

Related tasks

Creating a template

Related reference

Generate Database tab
Execute Sql tab