Generating SQL script files¶
The SQL generator¶
The SQL Designer module provides services used to generate SQL scripts from
table models.
The generated SQL script uses the characteristics of an SQL database schema
(create database, create table, alter table …) and takes into account all the
constraints described at table model level.
Generating an SQL script from a table model¶
To generate an SQL script file:
- The “Generator: SQL Script” command available on a DataBase type element is used to produce the SQL schema for this database:

The “Generator: SQL Script” command of the SQL Designer module¶
- A file export window appears in which you can specify a generation path before clicking on the “Export” button:

Window in which you can enter a generation path¶
- A “logicalmodel.sql” file is then generated.