Navicat has three ways to view object types in the main window, namely list, detailed information, and ER diagram. By default, Navicat uses List viewing object types. ER Diagram allows you to diagrammatically view the relationships between table fields and tables in a database or schema, and also allows you to add foreign key constraints directly to tables. This tutorial will explain in detail how Navicat generates ER diagrams.
The first step is to open Navicat and connect to the database.
The second step is to select View-> ER Chart from the main menu, or click the ER icon button in the lower right corner to switch the table data to the ER chart style.
Navicat for mysql usage graphic tutorial"
Navicat ER chart function is mainly reflected in the ability to use charts to View the relationship between table fields and tables in the database or schema. It also allows adding foreign key constraints directly to the table. The interface of the ER diagram is far superior to the list and detail interface. This is the biggest advantage for users of using the ER icon. reason.The above is the detailed content of How to generate er diagram in navicat. For more information, please follow other related articles on the PHP Chinese website!