我可以使用什么程序来生成 SQL 视图/表结构图?

发布于 2024-07-05 00:55:48 字数 1560 浏览 6 评论 0原文

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(5

妄想挽回 2024-07-12 00:55:48

如果您谈论的是 MS SQL Server 表,我喜欢 SQL Server Management Studio 中的图表支持。 您只需将表格从资源管理器拖到画布上,它们就会与关系线一起为您布置。 您必须手动进行一些调整才能获得最好看的图表,但这是获取图表的不错方法。

If you are talking about MS SQL Server tables, I like the diagram support in SQL Server Management Studio. You just drag the tables from the explorer onto the canvas, and they are laid out for you along with lines for relationships. You'll have to do some adjusting by hand for the best looking diagrams, but it is a decent way to get diagrams.

帝王念 2024-07-12 00:55:48

我更新了 Mark 关于 Toad Data Modeler 的帖子,并想指出他们有一个功能齐全且免费的测试版。 唯一的缺点是偶尔出现错误和内置过期(通常在新测试版可用时),但对于这个可怜的家伙来说,它确实创造了奇迹,直到我能让我的老板出钱获得许可证。

I upmodded Mark's post about Toad Data Modeler and wanted to point out that they have a beta version that is fully functional and free. The only downsides are the occasional bug and built in expiration (typically around the time a new beta is available), but for this poor bloke it does wonders until I can get my boss to chip in for a license.

遗失的美好 2024-07-12 00:55:48

我是 Embarcadero 的 ER/Studio 的忠实粉丝。 它功能非常强大,可以产生出色的屏幕和打印效果。 他们也有免费试用,所以你应该能够在没有太多冲突的情况下尝试一下。

祝你好运!

I am a big fan of Embarcadero's ER/Studio. It is very powerful and produces excellent on-screen as well as printed results. They have a free trial as well, so you should be able to get in and give it a shot without too much strife.

Good luck!

晚风撩人 2024-07-12 00:55:48

Quest 的 Toad Data Modeller 在这方面做得很好,而且价格合理。 正如 Bruce 提到的,Embarcadero E/R studio 也不错。

Toad Data Modeller from Quest does a nice job on this and is reasonably priced. Embarcadero E/R studio is good too, as Bruce mentioned.

赠佳期 2024-07-12 00:55:48

OP询问图表视图和视图依赖关系,SQL Management Studio和企业管理器不允许您图表视图。 我不能保证其他工具。

Visual Studio 的 LINQ to SQL 设计器确实允许您将视图拖放到设计图面上,但没有一种简单的方法可以对视图之间的依赖关系进行建模。 我不确定哪个工具具有这种类型的图表功能。 您可以查看 Red Gate 的 SQLDoc 工具,但它只提供基于文本的输出。

OP asked about diagramming views and view dependencies, SQL Management Studio and Enterprise Manager doesn't allow you to diagram views. I can't vouch for the other tools.

The LINQ to SQL designer for Visual Studio does allow you to drop views on the design surface but there isn't a easy way to model the dependencies between the views. I'm not sure which tool has this type of diagramming functionality. You could take a look at Red Gate's SQLDoc tool but it just provides text based output.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文