Generate table relationship diagram from existing schema (SQL Server)

Sql ServerDatabaseDiagram

Sql Server Problem Overview

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.

Sql Server Solutions

Solution 1 - 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

Solution 2 - Sql Server

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.

Solution 3 - Sql Server

SQLDeveloper can do this.

http://sqldeveloper.solyp.com/

Solution 4 - Sql Server

For SQL statements you can try reverse snowflakes. You can join at sourceforge or the demo site at http://snowflakejoins.com/.

Solution 5 - Sql Server

Why don't you just use the database diagram functionality built into SQL Server?

Solution 6 - Sql Server

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.

Solution 7 - Sql Server

DeZign for Databases should be able to do this just fine.

Solution 8 - Sql Server

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.

Solution 9 - Sql Server

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..

Categories
Recommended Sql Server Solutions
Recommended Database Solutions
Recommended Diagram Solutions

Previous Solution:

How do I Sort a Multidimensional Array in PHP

PhpSortingMultidimensional Array

Next Solution:

Do you use NULL or 0 (zero) for pointers in C++?

C++Null

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionNick ZalutskiyView Question on Stackoverflow
Solution 1 - Sql ServerGripsoftView Answer on Stackoverflow
Solution 2 - Sql ServerGeorgiView Answer on Stackoverflow
Solution 3 - Sql ServerSquareCogView Answer on Stackoverflow
Solution 4 - Sql ServerPascalView Answer on Stackoverflow
Solution 5 - Sql ServerMitchel SellersView Answer on Stackoverflow
Solution 6 - Sql ServerConcernedOfTunbridgeWellsView Answer on Stackoverflow
Solution 7 - Sql ServerThor HovdenView Answer on Stackoverflow
Solution 8 - Sql ServerSualeh FatehiView Answer on Stackoverflow
Solution 9 - Sql ServerdendiniView Answer on Stackoverflow