Is there a tool that will show diagrams of my SQL database in real-time?

Posted by Rising Star on Stack Overflow See other posts from Stack Overflow or by Rising Star
Published on 2010-06-09T20:51:47Z Indexed on 2010/06/09 21:02 UTC
Read the original article Hit count: 168

Filed under:
|

I've created some diagrams of SQL tables using the "Reverse Engineer" feature of Microsoft Office Visio. I like being able to visualize my relational databases in this manner.

However, what I get is just a static document that I can print, e-mail to colleagues, and click widgets on.

Earlier this year, I saw at a demo that the new version of Visual Studio 2010 has a new feature called the "Architect Explorer", which allows developers to view relationships among .net classes on the fly. It has many features for filtering the data that the developer is interested in.

It would be really awesome if I could visually browse my tables and stored procedures and see what is related to what by primary key, foreign key, and referenced in stored procedures. I realize that I'm talking about two entirely different technologies and it's not a perfect analogy, but is there some similar tool that would allow me to visualize tables in my SQL database?

© Stack Overflow or respective owner

Related posts about sql

Related posts about visualization