Generate table relationship diagram from existing schema (SQL Server)

Question

Is there a tool around that would produce a diagram showing existing tables and their relationships given a connection to a database or by any other means?

This is for SQL Server 2008 Express Edition.

Answer 1

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

Answer 2

Try DBVis - download at http://www.minq.se/products/dbvis/ - 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 ofr SQL Server, the tool shows tables and references orthogonal, hirarchical, in a circle ;-) etc. just by pressing one single button. I use the free version for years now.

Answer 3

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.

Answer 4

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 http://www.sqlmag.com/Article/ArticleID/94166/sql_server_94166.html

Answer 5

SQLDeveloper can do this.

http://sqldeveloper.solyp.com/

Answer 6

any schema diagram avaliable for SQL database latest version

Answer 7

any tools can generate relationship between tables in database with all detail like PK, FK,etc

thx

Answer 8

SchemaCrawler for SQL Server can generate database diagrams, with the help of GraphViz. Foreign key relationships are inferred, using naming conventions, and tables and columns can be excluded using regular expressions.