本文介绍了如何使用Microsoft SQL Server Management Studio生成数据库的实体关系(ER)图?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我想使用Microsoft SQL Server Management Studio生成SQL数据库的ER图,但是,我不知道该怎么做。



我在网上找到了此技术


I want to generate ER diagram of SQL database using Microsoft SQL Server Management Studio however, I dont know how to.

I found this technique online http://forums.asp.net/t/1790223.aspx?Making+ER+Diagram+from+SQL+Server+2008+Database

However, I am not able to see "Database Node" or "Database Diagrams" nodes as mentioned in the 1st and 2nd steps.

Hence, please let me know how can I generate ER diagram from an existing DB.

UPDATE:

From the comments below, I realize that I was right in my understanding that Database node means the node with my database name. But then my problem is I am not able to find the "Database Diagrams" node under my Database name. What should I do now so that I can see it.

PS: Its not a local database.

解决方案

You can save generated diagram for future use.

这篇关于如何使用Microsoft SQL Server Management Studio生成数据库的实体关系(ER)图?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

06-05 01:47
查看更多