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

visual studio database diagram (2)

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!

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?

OP asked about diagramming views and view dependencies, SQL Management Studio and Enterprise Manager doesn't allow you to diagram views. I can't vouch for the other tools.

The LINQ to SQL designer for Visual Studio does allow you to drop views on the design surface but there isn't a easy way to model the dependencies between the views. I'm not sure which tool has this type of diagramming functionality. You could take a look at Red Gate's SQLDoc tool but it just provides text based output.