September 12, 2003 at 8:13 am
I have a db that has 439 views, 187 tables, and 681 stored procs. My task is to propose a better db schema for a section of the db. Only I do not have an intimate knowledge of how the tables and views are stacked and dependant upon one another currently. Does anyone know how I can generate a diagram that will display the relationships of tables, to views and views to procs for a given table set and a given number of levels of dependency? I open to third party tool suggestions because if there isn't anything out there then I'm going to have to build it myself. :o(
K Leb
September 12, 2003 at 1:29 pm
Are you talking about something separate from the Database Diagram tool in Enterprise Manager?
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
September 12, 2003 at 1:34 pm
Try this for a 3rd party shareware. It's called Visual Database Designer:
http://www.downseek.com/download/4716.asp
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply