What program can I use to generate diagrams of SQL view/table structure? *

Question

I've been tasked with redesigning part of a ms-sql database structure which currently involves a lot of views, some of which contain joins to other views.

Anyway, I wonder if anyone here could recommend a utility to automatically generate diagrams to help me visualise the whole structure.

What's the best program you've used for such problems?

Answer

I am a big fan of Embarcadero's ER/Studio. It is very powerful and produces excellent on-screen as well as printed results. They have a free trial as well, so you should be able to get in and give it a shot without too much strife.

Good luck!

< br > via < a class="StackLink" href=" http://stackoverflow.com/questions/4110/" >What program can I use to generate diagrams of SQL view/table structure?< /a>

Share on Google Plus

About Cinema Guy

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.