Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.
Closed 10 years ago.
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
接受
或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论(9)
是的,您可以使用 SQL Server 2008 本身,但您需要安装 SQL Server Management Studio Express(如果未安装)。 只需右键单击数据库图并创建新图。 选择现有表,以及您是否已正确指定表中的引用。 您将能够看到所选表格的完整图表。
有关进一步参考,请参阅SQL Server 数据库入门图表
Yes you can use SQL Server 2008 itself but you need to install SQL Server Management Studio Express (if not installed ) . Just right Click on Database Diagrams and create new diagram. Select the exisiting tables and if you have specified the references in your tables properly. You will be able to see the complete diagram of selected tables.
For further reference see Getting started with SQL Server database diagrams
尝试 DBVis - 在 https://www.dbvis.com/download 下载 - 有一个专业版本 (不需要)和一个开放版本就足够了。
您所要做的就是为 SQL Server 获取正确的 JDBC - 数据库驱动程序,该工具只需按一个按钮即可显示正交、分层、圆形的表和引用;-) 等。 我使用免费版本已经很多年了。
Try DBVis - download at https://www.dbvis.com/download - there is a pro version (not needed) and a open version that should suffice.
All you have to do is to get the right JDBC - database driver for SQL Server, the tool shows tables and references orthogonal, hierarchical, in a circle ;-) etc. just by pressing one single button. I use the free version for years now.
SQLDeveloper 可以做到这一点。
http://sqldeveloper.solyp.com/
SQLDeveloper can do this.
http://sqldeveloper.solyp.com/
对于 SQL 语句,您可以尝试反向雪花。 您可以加入 sourceforge 或演示站点 http://snowflakejoins。 com/。
For SQL statements you can try reverse snowflakes. You can join at sourceforge or the demo site at http://snowflakejoins.com/.
为什么不直接使用 SQL Server 内置的数据库图表功能呢?
Why don't you just use the database diagram functionality built into SQL Server?
如果您创建数据库图表,Visio Professional 具有数据库逆向工程功能。 它不是免费的,但在大多数公司中相当普遍,并且应该很容易获得。
请注意,Visio 2003 不能与 SQL2005 或 SQL2008 很好地配合进行逆向工程 - 您需要使用 2007。
Visio Professional has a database reverse-engineering feature if yiu create a database diagram. It's not free but is fairly ubiquitous in most companies and should be fairly easy to get.
Note that Visio 2003 does not play nicely with SQL2005 or SQL2008 for reverse engineering - you will need to get 2007.
DeZign for Databases 应该能够很好地做到这一点。
DeZign for Databases should be able to do this just fine.
SchemaCrawler for SQL Server 可以在 GraphViz 的帮助下生成数据库图表。 显示外键关系(甚至可以使用命名约定推断),并且可以使用正则表达式排除表和列。
SchemaCrawler for SQL Server can generate database diagrams, with the help of GraphViz. Foreign key relationships are displayed (and can even be inferred, using naming conventions), and tables and columns can be excluded using regular expressions.
MySQL WorkBench 是免费软件,由 Oracle 开发,您可以导入 SQL 文件或指定数据库,它会生成 SQL 图,您可以移动该图以使其更具视觉吸引力。
它在 GNU/Linux 和 Windows 上运行,免费且具有专业的外观。
MySQL WorkBench is free software and is developed by Oracle, you can import an SQL File or specify a database and it will generate an SQL Diagram which you can move around to make it more visually appealing.
It runs on GNU/Linux and Windows and it's free and has a professional look..