Reverse engineering means retrieving information about the database structure. It is about finding out what objects exist in the database, such as tables, columns, views, procedures, etc., and what relationships exist between these objects. Based on this information, it is possible to draw an ER diagram in which the relationships can be clearly displayed.
To create an ER diagram of an existing database, it is necessary to connect to the database and retrieve this information.
Using an existing database connection
If you have already created a database connection, select it and click Connect and load existing database structure. This will start a process that will result in a new project with an ER diagram.
This option is available for the following relational and noSQL databases:
Import from files
This feature is available for
- SQLite and
Connection to SQLite database is not classic, so you will not find the option of this database in the connections section. To visualize an existing SQLite database structure, go to the Projects section and import SQLite from a file.