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?
Thanks,
GBHave you tried the SQL Server Diagraming tools ? This will at least be
able to give you data model to work with. I recall somewhere that
coding some nifty SQL SMO may help.
MJKulangara
http://sqladventures.blogspot.com|||I tried to create database diagrams but it shows table relations only.
GB
"MJKulangara" <RutgersDBA@.gmail.com> wrote in message
news:1138914523.816837.42350@.o13g2000cwo.googlegro ups.com...
> Have you tried the SQL Server Diagraming tools ? This will at least be
> able to give you data model to work with. I recall somewhere that
> coding some nifty SQL SMO may help.
> MJKulangara
> http://sqladventures.blogspot.com|||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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
