The nice thing about this approach is that your diagram is also your database so you don't have to create the diagram and then create the database, you can get them both done at the same time.
You can do this inside Visual Studio. Just set up a Database and in the Server Explorer, create a new diagram. The way to do this differs in different VS Versions.
发布评论
评论（3）
此 http://msdn.microsoft.com/en -us/library/ms171971%28VS.80%29.aspx 文章很好地解释了如何使用 Microsoft SQL Management Studio 创建数据库图表。您可以在此处下载 SQLMS：http://www.microsoft.com/express/Database/
这种方法的好处是您的图表也是您的数据库，因此您不必创建图表然后创建数据库，您可以同时完成它们。
This http://msdn.microsoft.com/en-us/library/ms171971%28VS.80%29.aspx article explains pretty well how to create database diagrams using Microsoft SQL Management Studio. You can download SQLMS here: http://www.microsoft.com/express/Database/
The nice thing about this approach is that your diagram is also your database so you don't have to create the diagram and then create the database, you can get them both done at the same time.
我非常喜欢使用 Microsoft Visio 来绘制此类内容。
或者更好 - 一块擦拭板！
I quite like to use Microsoft Visio to map this sort of stuff out.
Or even better - a wipeboard!
您可以在 Visual Studio 中执行此操作。只需设置一个数据库，然后在服务器资源管理器中创建一个新图表。不同的 VS 版本执行此操作的方法有所不同。
VS 2005
另一种方法是使用Management Studio Express
您可以获取此 这里。
You can do this inside Visual Studio. Just set up a Database and in the Server Explorer, create a new diagram. The way to do this differs in different VS Versions.
VS 2005
Another approach would be to use the Management Studio Express
You can get this one here.