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.
SQLite and import from files
Connection to SQLite database is not classic, so you will only need to specify the connection name and the path to the SQLite database file.