SQL Server中的数据库模式图 [英] Database Schema Diagram From SQL Server

问题描述

Visio是这里的唯一方式

我看到了另一个stackoverflow的问题 http://stackoverflow.com/questions/30474/database-schema-diagram-design-tool

虽然Sql设计器是好的，我不想手工绘制所有的表 - 有任何方法来短路这个和上传SQL DDL，并生成图表中的表??

Is Visio the only way here??

I saw another stackoverflow question about this http://stackoverflow.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??

解决方案

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

这篇关于SQL Server中的数据库模式图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！