从现有模式（SQL Server）生成表关系图 [英] Generate table relationship diagram from existing schema (SQL Server)

问题描述

这是SQL Server 2008 Express Edition的版本。

是>您可以使用SQL Server 2008本身，但您需要安装SQL Server Management Studio Express（如果没有安装）。只需右键单击数据库图并创建新图。选择现有表，并且正确地指定表中的引用。您将能够看到所选表的完整图表。
进一步参考：

• 跳转开始：创建数据库图表或


• SQL Server数据库图表入门

Is there a way to produce a diagram showing existing tables and their relationships given a connection to a database?

This is for SQL Server 2008 Express Edition.

解决方案

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:

• Jump Start: Creating Database Diagrams, or
• Getting started with SQL Server database diagrams

这篇关于从现有模式（SQL Server）生成表关系图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！