SQL可视化软件
我有一个大的 .sql 表文件 - 是否有软件可以根据 SQL 文件自动生成可视化的表簇(因为它们通过外键相关)?
I have a large .sql file of tables -- is there software that can auto-generate visual clusters of tables (as they are related by foreign keys) based on a SQL file?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
我认为您正在寻找像这样的工具: https://sqlflow.gudusoft.com/#/< /a>
它为您提供可视化 SQL 以及生成正确的 ER 图的选项。您可以上传 SQL 文件或直接粘贴 SQL 语句。
有关更多信息,您可以查看他们的文档:https://docs.gudusoft.com/1。 -简介/自述文件
I think you are looking for some tools like this one: https://sqlflow.gudusoft.com/#/
It offers you the option to visualize the SQL as well as generate proper E-R diagram. You can either upload the SQL file or directly paste your SQL statements.
For more info you can check their doc:https://docs.gudusoft.com/1.-introduction/readme
如果您使用的是 MySQL,请查看 MySQL Workbench。
If you're using MySQL, take a look at MySQL Workbench.
您需要谷歌“实体关系图” - 有几种工具,其中许多是企业级的并且昂贵。我用过 ErWin 和 StarDesigner。
You need to google "Entity Relationship diagram" - there are several tools, many of them enterprise and expensive. I've used ErWin and StarDesigner.