Introducing SQL Designer¶
Welcome to the SQL Designer user guide!
The SQL Designer module is a Modelio extension dedicated to generating and reversing SQL script files.

The SQL Designer interface¶
The SQL Designer module provides the following features:
- Graphical representation and modeling of an SQL model:
- At the conceptual level (data model)
- At the logical level (table model)
- Transformation of a data model into a table model, and of a table model into a data model
- Generation of SQL script files from a table model (logical model)
- Reverse of SQL script files: Reverse of SQL database scripts to a table model.
- Integration with the Hibernate Designer module: Used in conjunction with the Hibernate Designer module, SQL Designer generates the database script, the Java data model and the Hibernate mapping files between the database and the data model.
Note: In order to get the most out of Hibernate Designer, you must be familiar with Modelio. If this is not the case, have a look at the Modelio user guides and learn how to use our tool.