| |
Reverse DDL to ERD models
A DDL (Data Definition Language) file is a computer language for defining data. Now, you can also use it to generate ERD models like entities, views and relationships by reversing the DDL.
| Reversing DDL |
|
| 1. |
Here shows an extraction of the DDL file for MySQL database that we are going to reverse. |
|
 |
|
| 2. |
To reverse DDL, select menu Tools > Reverse DDL.... |
|
 |
|
| 3. |
In the Reverse DDL dialog box, type the path of DDL file in File path, and select the target database of this DDL in the Database list. |
|
 |
|
| 4. |
After reversing, the models like entities, columns and relationships are generated according to the DDL. |
|
 |
|
| 5. |
You can select interested models in Model pane, right-click on them and select Form ER Diagram from the popup menu to generate an ERD. |
|
 |
|
Resources
|
