List of supported SQL dialects
Importing a .sql file into the engine #
From the Designer, click
Tools on the top bar and choose the
Import SQL Schema option from the drop-down menu. From the Import SQL into model panel, click on the first icon at the top left, select the desired .sql file, and click on the button Import SQL .
The SQL Schema Importer panel allows you to import and edit any supported .sql file.
At any time, you can check the validity of the SQL script by clicking the Validate button. If parsing is successful, the message
SQL script appears to be valid appears. If not, the parser highlights the line on which the compilation error is present, and you must manually intervene on the file to remove the SQL construct is not supported.
Newly created classes will be visible in a new diagram within the engine
When the data type of an attribute is not supported, it is marked as
unknown and a message appears in the Designer alerting the user to the error. In order for the model to be saved, all unrecognized data types must be changed manually by the user.
By importing a .sql file more than once, the Designer automatically resolves conflicts by renaming duplicate elements appropriately (e.g., if you import a
Class table twice, it will become
Class_1 in the diagram created during the second import.
Dumping a SQL Schema from the Dashboard
Let’s now look at an application scenario for this tool. To get started, download the example .sql file by clicking on the button below:
This script defines a SQL Schema in which there are three tables with references to foreign keys. For the attributes within the classes, the Importer correctly recognizes both integrity constraints and unique constraints.
Before proceeding with the import, verify that the file you downloaded is free of errors by pressing the Validate button.
Once you press Import SQL , the
The selected classes and relations have been successfully imported in the current model message appears and a new diagram is created in the engine, with within it the classes and relationships shown in the following image: