我可以看到这篇文章已经很老了，当时 MS SQL Server Management Studio 可能还没有这个功能！ 据我所知，使用 SQL Server 2012，您可以通过执行下面列出的几个简单步骤来生成 ER 图：
MS SQL Server Management Studio > 文件菜单> “连接对象资源管理器”
选择您的数据库节点并将其展开。 在此节点下，您将找到一个名为“数据库图”的子节点，
右键单击“数据库图”> “新数据库图表”> 添加您希望查看其列、关系等的表
I can see that this post is quite old and MS SQL Server Management Studio might have not had this feature back then! Though as far as I know with SQL Server 2012 you can generate the ER diagrams by taking a few simple steps listed below:
MS SQL Server management Studio > File menu > "Connect Object Explorer"
Choose your Database node and expand it. under this node you'll find a sub-node called "Database Diagrams"
Right click on "Database Diagrams" > "New Database Diagram" > Add tables that you wish to see their columns, relationships, ...
Microsoft Visio 的数据库逆向工程功能非常适合从数据库中提取架构并从那里进行开发。 如果你还没有调查过的话，我会调查一下。
The database reverse engineering feature of microsoft Visio are excellent for pulling the schema out of a database and developing from there. I'd investigate that avenue if you haven't already.
我使用过 Visio，并取得了一些不错的结果。 我也做的一件事是使用 SQL Server GUI 中内置的可视化设计器（数据库图）。 当您将表放入其中时，它会自动包含外键。 您此时可以只包含您想要关注的表。
但所有这些工具都预测预先存在的外键。
I've used Visio and had some good results with that. One thing I do though too is to use the visual designers (Database Diagrams) built into SQL Server GUI. When you drop the tables in there, it automatically includes the foreign keys. You can just include the tables you want at this point to focus in.
All of these tools though anticipate the foreign keys pre-existing.
发布评论
评论（5）
我可以看到这篇文章已经很老了，当时 MS SQL Server Management Studio 可能还没有这个功能！ 据我所知，使用 SQL Server 2012，您可以通过执行下面列出的几个简单步骤来生成 ER 图：
I can see that this post is quite old and MS SQL Server Management Studio might have not had this feature back then! Though as far as I know with SQL Server 2012 you can generate the ER diagrams by taking a few simple steps listed below:
Microsoft Visio 的数据库逆向工程功能非常适合从数据库中提取架构并从那里进行开发。 如果你还没有调查过的话，我会调查一下。
The database reverse engineering feature of microsoft Visio are excellent for pulling the schema out of a database and developing from there. I'd investigate that avenue if you haven't already.
我使用过 Visio，并取得了一些不错的结果。 我也做的一件事是使用 SQL Server GUI 中内置的可视化设计器（数据库图）。 当您将表放入其中时，它会自动包含外键。 您此时可以只包含您想要关注的表。
但所有这些工具都预测预先存在的外键。
I've used Visio and had some good results with that. One thing I do though too is to use the visual designers (Database Diagrams) built into SQL Server GUI. When you drop the tables in there, it automatically includes the foreign keys. You can just include the tables you want at this point to focus in.
All of these tools though anticipate the foreign keys pre-existing.
我对 DBDesigner4 很满意。
I've been happy with DBDesigner4.
您还可以从 Microsoft Visual Studio 2005 生成 ERD。
You can also generate an ERD from Microsoft Visual Studio 2005.