Print As, and then select the file format you want to save."/> Print As, and then select the file format you want to save.">
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: Click the button in the lower right corner to switch to the ER view: 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. 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. 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!