Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of generating er diagrams for navicat. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

There are three ways for Navicat to view object types in the main window: lists, details, and ER diagrams. By default, Navicat uses list to view object types. ER charts can use diagrams to view the relationship between table columns and tables in a database or schema, and allow foreign keys to be added directly to tables.

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 style of the ER chart.

Navicat ER chart function is mainly reflected in the chart to view the relationship between the table column and the table in the database or schema, it also allows the direct addition of foreign keys to the table, the interface of ER chart is far better than the interface of lists and details, which is the biggest reason for users to use the ER icon.

Warm reminder: the function of Navicat to generate ER charts is limited to the full version, and other versions do not enjoy this feature. And only table data provides ER chart view, other types of data do not provide ER chart view, other database objects only provide list and details view.

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

This is the end of this article on "the method of navicat generating er diagram". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.