The SQL Designer module provides a feature used to transform a conceptual model (or data model) into a logical model (or table model).
To create a table model from the current datamodel, the "Transform Data model into table model " command, available on "DataModel " type elements, is used.
-
If no table model linked to this data model exists yet, a new table model is created. You will be asked to choose the type of table model (MySQL, Oracle, SQLServer) you want to create in a dedicated window.
-
If a table model already exists, it is updated to take into account the modifications carried out in the data model.