Posted by Erland Sommarskog on 02/03/06 00:09

GB (v7v1k3@hotmail.com) writes:
> In my SQL Server databases I have complex related tables and views.
> There is any tool which allow you to see (print) this complex hierarchy of
> views and tables as hierarchical tree?

There are several data-modelling tools on the market, that are quite
more eloquent and powerful than the built-in diagamming in SQL Server.
They are also more expensive...

Anyway, the leaders in this field are PowerDesigner (from Sybase), ErWin
(now from Computer Associates) and Embrocadero's tool. I use PowerDesigner
myself, but I don't think it has that much support for showing relation
for views, actually. Then again, I use views very little, so I may have
missed how it works.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]