Generate SQL DDL

A Specified Data Model "data" that is stored in a Subject, Entities, Attributes, and Keys can be used to generate a SQL DDL export file. This file can then be imported into an SQL-engine based DBMS or possibly to a database diagrammer. The one employed by Whitemarsh is Dezign by It is inexpensive and very capable. There are two buttons at the right side of the screen, View Generation Result and Data Model Diagrammer. Properly linked by embedding a Windows Short Cut, the diagrammer will begin to execute. It can then read the Generated SQL DDL file and a diagram can be shown.  The process to accomplish the generation of the SQL DDL includes:

  • Start the Specified Data Model Metabase System Module
  • Select the DBMS
  • Enter User Name and Password
  • Select the Menu Item, Subjects & Entities, then the subordinate item, SQL DDL, and finally the Generate process
    • Highlight the appropriate Subject
    • If a Specified Data Model tree hierarchy is to be dynamically created, select the entity around which the data model hierarchy is to be created.
      • Press the Display Specified Data Model Diagram
    • If a SQL DDL output file is to be created,
      • Select the output file
      • Clear the output file
      • Select how Super & Subtype entities are to be processed
      • Press either the Generate Subject based data model button, or the Generate root-entity based data model
  • Press either the View Generation Result or
  • Press the Data Model Diagrammer button

For Sales and Corporate: 1-301-249-1142

Whitemarsh Information Systems Corporation

 Bowie, Maryland 20716 USA

Copyright 1981 - 2020 Whitemarsh Information Systems Corporation
Proprietary Data, All rights Reserved