Print As, and then select the file format you want to save."/> Print As, and then select the file format you want to save.">

Home  >  Article  >  Database  >  How to export er diagram from navicat

How to export er diagram from navicat

angryTom
angryTomOriginal
2019-08-10 13:49:395673browse

How to export er diagram from navicat

Usually managing the database usually uses the cmd command prompt or the Data source that comes with IDEA Intellij. Navicat is rarely used. During this period, due to the need to design the data structure for front-end and back-end interaction, it was somewhat difficult to directly write documents to contact multiple tables. I thought it would be much more intuitive if there was a relationship diagram. Thinking that Navicat itself has this function, I will try it now.

Recommended tutorial: navicat usage tutorial

##First, we open the designed table view interface:

How to export er diagram from navicat

Click the button in the lower right corner to switch to the ER view:

How to export er diagram from navicat

Those tables are connected by foreign keys. , this should be no problem. Then, I thought that I wanted to report my work situation to my boss. A direct screenshot would not be complete, and it would be very vague. So I thought, is there any way to export the obtained relationship diagram into a pdf or image format file? After searching for a while, I found that this function does exist.

How to export er diagram from navicat

Right-click on the database name and select Reverse Database to Model. You can see that the generated model may have some deviations, but the relationship will not change. Of course, you can also select the corresponding line or something in the toolbar on the left, continue processing, and then choose to export.

How to export er diagram from navicat

There are three export formats, pdf, svg and png. Personally, I prefer pdf, which is more formal. Generally, I will convert any document I want to report to my boss into pdf first. This is also a bit more refreshing. emmm, that’s it for generating ER diagram and exporting it. If it helped you, please give it a like!

The above is the detailed content of How to export er diagram from navicat. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn