Is Visio the only way here??
Visio是唯一的方式吗？
I saw another * question about this https://*.com/questions/30474/database-schema-diagram-design-tool
我看到另一个关于此https://*.com/questions/30474/database-schema-diagram-design-tool的*问题
And whilst Sql Designer is nice I dont want to draw all the tables by hand - Is there any way to short circut this and upload SQL DDL and it generates the tables in a diagram??
虽然Sql Designer很好我不想手工绘制所有表 - 有没有办法短路这个并上传SQL DDL并在图中生成表？
2 个解决方案
#1
8
MS SQL Server has built - in Data Schema diagramming tool (in the SQL Server Management Studio). Just right click on the database diagrams node in the tree under the database you want to create a schema from... Once you have an empty diagram object, you can even create actual database tables directly on the diagram
MS SQL Server具有内置的数据架构图表工具（在SQL Server Management Studio中）。只需右键单击要从中创建模式的数据库树下的数据库图表节点...一旦有了一个空图表对象，您甚至可以直接在图表上创建实际的数据库表
#2
2
MS Visio has a function to generate a database diagram from an existing database. For Vision 2008 go to Tools->Add-Ons->Visio Extras->Database Wizard. I used it a few years ago, but have no sql server at hand to test it right now.
MS Visio具有从现有数据库生成数据库图表的功能。对于Vision 2008，请转到工具 - >附加组件 - > Visio Extras->数据库向导。几年前我用过它，但是现在没有sql server来测试它。
EDIT: Just saw that you specifically asked for SQL Designer. Have a look at the manual.
编辑：刚看到你特意要求SQL Designer。看一下手册。
Basics
基本
The application allows you to:
该应用程序允许您：
...
...
- Import DB schemas
- 导入数据库架构
#1
8
MS SQL Server has built - in Data Schema diagramming tool (in the SQL Server Management Studio). Just right click on the database diagrams node in the tree under the database you want to create a schema from... Once you have an empty diagram object, you can even create actual database tables directly on the diagram
MS SQL Server具有内置的数据架构图表工具（在SQL Server Management Studio中）。只需右键单击要从中创建模式的数据库树下的数据库图表节点...一旦有了一个空图表对象，您甚至可以直接在图表上创建实际的数据库表
#2
2
MS Visio has a function to generate a database diagram from an existing database. For Vision 2008 go to Tools->Add-Ons->Visio Extras->Database Wizard. I used it a few years ago, but have no sql server at hand to test it right now.
MS Visio具有从现有数据库生成数据库图表的功能。对于Vision 2008，请转到工具 - >附加组件 - > Visio Extras->数据库向导。几年前我用过它，但是现在没有sql server来测试它。
EDIT: Just saw that you specifically asked for SQL Designer. Have a look at the manual.
编辑：刚看到你特意要求SQL Designer。看一下手册。
Basics
基本
The application allows you to:
该应用程序允许您：
...
...
- Import DB schemas
- 导入数据库架构