How to generate er diagram in navicat

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.

##Related recommendations: "

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.

Warm reminder: Navicat's function of generating ER diagrams is only available in the full version, and other versions do not enjoy this function. And only table data provides ER chart viewing. Other types of data do not provide ER chart viewing. Other database objects only provide list and detailed information viewing.

If the selected database or schema contains tables, an ER diagram will be automatically created and can be viewed by clicking the ER diagram button. In addition, you need to understand that ER chart files are all saved in the set location and the format is .ned.

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!