如何根据现有表建立数据库图表？
我有一个包含近 300 个表的数据库，我刚刚遇到一个问题，我在图表中添加了近 60 个表。如果我将页面缩放设置为 %10，我只能查看整个页面，这并不是很有用。有人对这个问题有什么建议吗？我需要查看图表，这是能够查看更有用的方式。如果该建议是 SQL Server 2008 内置功能之一，我将不胜感激。谢谢。
I have a database which has almost 300 tables, I've just come across with a problem that I've added almost 60 tables into my diagram. I can only view the entire page if I set the page zoom to %10 and it's not really useful. Anyone has any suggestions for the problem? I need to view the diagram which is able to view more useful way. If the suggestion will be one of the SQL Server 2008 built-in features I'd appreciate. Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
对于这种情况，我构建了几个图表，每个图表都有表的逻辑子集。如果将其分解，将更容易理解包含这么多表的架构。
另一方面，如果您正在寻找“架构墙”并且只想制作一张大海报来给人留下深刻印象，我会使用 Visio 对架构进行逆向工程。它在表格布局方面提供了更多选项。
For this situation I build several diagrams, each with logical subsets of tables. It is going to be easier to understand the schema with that many tables if you break it up.
On the other hand, if you are looking for the "wall of schema" and just want to make a big poster to impress people, I would use Visio to reverse engineer the schema. It provides a lot more options in terms of how the tables get layed out.
您可以以 100% 缩放比例复制整个图表，并将其作为位图粘贴到您最喜欢的任何图像编辑器中，以便进一步细读。 :)
You can copy the whole diagram at zoom 100% and paste it as bitmap in any of your favorite image editors for further perusal. :)
创建专注于数据库特定部分的图表。
创建一个新图表，仅向其中添加特定区域的现有表：订单、患者等。不要尝试创建一个包含所有内容的图表，除非您想一次查看其中的一小部分。
create your diagrams that focus on a certain portion of your database.
create a new diagram, add only the existing tables to it for a certain area: orders, patients, etc. don't try to have an all inclusive diagram, unless you want to view small portions of it at one time.