blocks|key|2688192|text|从SQL+Server+Management+Studio的对象资源管理器中，找到您的数据库并展开该节点(单击数据库旁边的%2B号)。该展开树中的第一个项目是数据库关系图。右键单击它，您将看到各种任务，包括创建新的数据库图。如果您以前从未创建过图表，它将询问您是否要安装用于创建图表的组件。单击yes，然后继续。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2688193|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

From Object Explorer in SQL Server Management Studio, find your database and expand the node (click on the + sign beside your database). The first item from that expanded tree is Database Diagrams. Right-click on that and you'll see various tasks including creating a new database diagram. If you've never created one before, it'll ask if you want to install the components for creating diagrams. Click yes then proceed.

blocks|key|2900546|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2900547|转到Sql+Server+Management+Studio+>|ordered-list-item|2900548|Object+Explorer+>|2900549|Databases+>|2900550|选择并展开数据库数据库右击“数据库关系图”，然后选择“新建数据库关系图”。|2900551|它将打开一个新窗口。选择要包含在ER图中的表(要选择多个表，请按"ctrl“或"shift”按钮并选择tables).|2900552|Click+add。|2900553|等待其完成。完成！|2900554|2900555|您可以保存生成的图表以供将来使用。|2900556|​|2900557|📷|atomic|offset|length|2900558|2900559|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/efc982d9c9b0a031daa68755ce780d47.png|imageAlt^0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|-4|4|5|6|19|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|1A|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|1B|7|@]|8|@]|9|$]]|$1|F|3|G|4|C|6|1C|7|@]|8|@]|9|$]]|$1|H|3|I|4|C|6|1D|7|@]|8|@]|9|$]]|$1|J|3|K|4|C|6|1E|7|@]|8|@]|9|$]]|$1|L|3|M|4|C|6|1F|7|@]|8|@]|9|$]]|$1|N|3|O|4|C|6|1G|7|@]|8|@]|9|$]]|$1|P|3|-4|4|5|6|1H|7|@]|8|@]|9|$]]|$1|Q|3|R|4|5|6|1I|7|@]|8|@]|9|$]]|$1|S|3|T|4|5|6|1J|7|@]|8|@]|9|$]]|$1|U|3|V|4|W|6|1K|7|@]|8|@$X|1L|Y|1M|1|1N]]|9|$]]|$1|Z|3|T|4|5|6|1O|7|@]|8|@]|9|$]]|$1|10|3|-4|4|5|6|1P|7|@]|8|@]|9|$]]]|11|$12|$4|13|14|15|9|$16|17|18|-4]]]]

<ol>
<li>Go to Sql Server Management Studio &gt;</li>
<li>Object Explorer &gt;</li>
<li>Databases &gt;</li>
<li>Choose and expand your Database.</li>
<li>Under your database right click on &quot;Database Diagrams&quot; and select &quot;New Database Diagram&quot;.</li>
<li>It will a open a new window. Choose tables to include in ER-Diagram (to select multiple tables press &quot;ctrl&quot; or &quot;shift&quot; button and select tables).</li>
<li>Click add.</li>
<li>Wait for it to complete. Done!</li>
</ol>
You can save generated diagram for future use.
<a href="https://i.stack.imgur.com/L32cq.png" rel="noreferrer"><img src="https://i.stack.imgur.com/L32cq.png" alt="screenshot" /></a>

blocks|key|2900561|text|截至2019年6月11日的版本，图表又回来了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2900562|Download+latest|offset|length|2900563|如上所述：|2900564|2900565|是的，我们已经听到了反馈；数据库图表又回来了。|blockquote|2900566|2900567|2900568|SQL+Server+Management+Studio+(SSMS)+18.1+is+now+generally+available|2900569|2900570|最新版本的不包含⚠️⚠️|style|BOLD|2900571|遗憾的是，将数据库图作为特性的SSMS的最后一个版本是v17.9。|2900572|从该版本开始，从v18.*开始的较新的预览版，用他们的话来说就是"...feature已被弃用“。|2900573|尽管如此，希望并没有失去，因为人们仍然可以download并使用v17.9来使用数据库图表，作为对这个问题的补充，从技术上讲，它不是一个ER图表工具。|2900574|2900575|在撰写本文时，还不清楚18的发行版是否会有这个功能，我希望是这样，因为它是我广泛使用的一个功能。|2900576|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15|1|https://cloudblogs.microsoft.com/sqlserver/2019/06/11/sql-server-management-studio-ssms-18-1-is-now-generally-available/|2|https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017^0|0|0|F|0|0|0|0|0|0|0|0|1V|1|0|0|5|3|0|0|0|L|8|2|0|0|0^^$0|@$1|2|3|4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1G|8|@]|9|@$D|1H|E|1I|1|1J]]|A|$]]|$1|F|3|G|5|6|7|1K|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1M|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1P|8|@]|9|@$D|1Q|E|1R|1|1S]]|A|$]]|$1|P|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1U|8|@$D|1V|E|1W|S|T]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1X|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1Z|8|@]|9|@$D|20|E|21|1|22]]|A|$]]|$1|10|3|-4|5|6|7|23|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|24|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|25|8|@]|9|@]|A|$]]]|14|$15|$5|16|17|18|A|$19|1A]]|1B|$5|16|17|18|A|$19|1C]]|1D|$5|16|17|18|A|$19|1E]]]]

Diagrams are back as of the June 11 2019 release 

<a href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15" rel="nofollow noreferrer">Download latest</a>

as stated:

<blockquote>
 Yes, we’ve heard the feedback; Database Diagrams is back.
</blockquote>

<a href="https://cloudblogs.microsoft.com/sqlserver/2019/06/11/sql-server-management-studio-ssms-18-1-is-now-generally-available/" rel="nofollow noreferrer">SQL Server Management Studio (SSMS) 18.1 is now generally available</a>

<hr>

⚠️ Latest Version Does Not Included It ⚠️

Sadly, the last version of SSMS to have database diagrams as a feature was version v17.9. 

Since that version, the newer preview versions starting at v18.* have, in their words "...feature has been deprecated". 

Hope is not lost though, for one can still <a href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017" rel="nofollow noreferrer">download</a> and use v17.9 to use database diagrams which as an aside for this question is technically not a ER diagramming tool.

<hr>

As of this writing it is unclear if the release version of 18 will have the feature, I hope so because it is a feature I use extensively.

blocks|key|2900615|text|截至2019年10月，SQL+Server+Management+Studio尚未升级SSMS以添加创建ER图功能。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2900616|我建议在这里尝试使用DBWeaver：|2900617|https://dbeaver.io/download/|offset|length|2900618|我使用的是Mac和Windows，我能够下载社区版并登录到我的SQL服务器数据库，并且能够使用DB+Weaver创建ER图。|2900619|​|2900620|📷|atomic|2900621|2900622|entityMap|0|LINK|mutability|MUTABLE|url|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/8d38ada3fb971b788ee97fbfef033a3b.png|imageAlt^0|0|0|0|S|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@$F|15|G|16|1|17]]|A|$]]|$1|H|3|I|5|6|7|18|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|19|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1A|8|@]|9|@$F|1B|G|1C|1|1D]]|A|$]]|$1|O|3|K|5|6|7|1E|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|E]]|W|$5|X|T|Y|A|$Z|10|11|-4]]]]

As of Oct 2019, SQL Server Management Studio, they did not upgraded the SSMS to add create ER Diagram feature.

I would suggest try using DBWeaver from here :

<a href="https://dbeaver.io/download/" rel="noreferrer">https://dbeaver.io/download/</a>

I am using Mac and Windows both and I was able to download the community edition and logged into my SQL server database and was able to create the ER diagram using the DB Weaver.

<a href="https://i.stack.imgur.com/4MgIk.png" rel="noreferrer"><img src="https://i.stack.imgur.com/4MgIk.png" alt="ER Diagram using the Community Version Db Viewer"></a>

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 <a href="http://forums.asp.net/t/1790223.aspx?Making+ER+Diagram+from+SQL+Server+2008+Database" rel="noreferrer">http://forums.asp.net/t/1790223.aspx?Making+ER+Diagram+from+SQL+Server+2008+Database</a>

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.

How to generate Entity Relationship (ER) Diagram of a database using Microsoft SQL Server Management Studio?

SQL数据库

SQL Server

数据库

服务器

Windows

我想用Microsoft SQL Server Management Studio生成SQL数据库的ER图，但是我不知道怎么做。我在上找到了这个技巧但是，我看不到第一步和第二步中提到的“数据库节点”或“数据库图”节点。因此，请让我知道如何从现有的数据库生成ER图。更新：从下面的评论中，我意识到我对数据库节点的理解是正确...

问如何使用Microsoft SQL Server Management Studio生成数据库的实体关系(ER)图？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Microsoft SQL Server Management Studio生成数据库的实体关系(ER)图？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Microsoft SQL Server Management Studio生成数据库的实体关系(ER)图？
EN