从任何 sql 语句生成数据库图
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7722762/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Generate db diagram from any sql statement
提问by Carlos Jaime C. De Leon
I'm using DBArtisan 8.5.5 and it has the ability to generate Database Diagrams using Build Query, it has a nice feature that lets it autojoin, detecting potential relationships on newly added tables to the diagram. So the diagram results into a SQL statement since its a Query Builder after all.
我使用的是 DBArtisan 8.5.5，它能够使用 Build Query 生成数据库图表，它有一个很好的功能，可以自动加入，检测新添加到图表的表上的潜在关系。所以这个图最终会变成一个 SQL 语句，因为它毕竟是一个查询生成器。
Is it possible to provide an SQL statement in DBArtisan and generate the Database Diagram? In other words, the reverse (give it the SQL to generate the diagram, instead of using diagrams to generate SQL)?
是否可以在 DBArtisan 中提供 SQL 语句并生成数据库图？换句话说，反过来（给它SQL生成图表，而不是使用图表生成SQL）？
If no such feature, is there a product out there for Sybase DB that will provide said feature?
如果没有这样的功能，是否有用于 Sybase DB 的产品可以提供所述功能？
回答by Julio Cezar Silva
DbVisis an actionable choice, being open source and powerful - it's got a good amount of extra featuresaside from the one you need.
DbVis是一个可行的选择，它是开源且功能强大的 -除了您需要的功能之外，它还具有大量额外功能。
If you're willing to pay, Aqua Data Studiois a very complete and intuitive database IDE.
如果你愿意付费，Aqua Data Studio是一个非常完整和直观的数据库 IDE。
As a middle ground solution, disposing of both a - constantly updated - open source edition, the DBeaver Open Source IDE, and an Enterprise Edition. Both of these also offer what you need, the main differences as of now being interface, SSH algorithm support and SQL debugging framework offered in Enterprise. You can take a deeper look yourself, comparing the Open Source featureswith the Enterprise ones.
作为中间解决方案，同时处理不断更新的开源版本、DBeaver 开源 IDE和企业版。这两者也提供了您所需要的，目前的主要区别在于 Enterprise 中提供的接口、SSH 算法支持和 SQL 调试框架。您可以更深入地了解自己，将开源功能与企业功能进行比较。
