Previous Topic: Data Model TransformationNext Topic: RI Trigger Generation

BLOB › Construction and Test › Database Generation › DDL Generation

DDL Generation

We are now ready to generate the DDL. Because we are just introducing a new table, and that table contains the foreign keys, we need only to generate the DDL for that table.

Follow these steps:

  1. Open the DDL Generation dialog and then from the Menu Bar click Options, Generation Defaults. Verify the generation default settings look as follows (assuming you are targeting MS/SQL):

    Generation Defaults dialog

  2. In the DDL Generation dialog, select the SCORE_CARD table and CARDID index for generation and installation as follows:

    Select the SCORE_CARD table and CARDID index for generation and installation in the DDL Generation dialog

  3. From the Menu Bar, click Generate, DDL, Selected. The DDL Generation dialog will change to report that the generation completed and then will automatically launch the Build Tool.
  4. The Build Tool will open and you may be prompted to logon to the database. If everything completes successfully, the Build Tool displays the Build-OK status as follows:

    Build Tool displaying the Build-OK status