Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Database diagrams 1

Status
Not open for further replies.

ksbigfoot

Programmer
Apr 15, 2002
856
CA
This might be a simple question for some people, but I have always wondered about it.
We are using SQL Server 8 and we have about 180 tables.
I am creating a diagram, but it is getting quite big and I have to scroll a lot.
Some of our areas only have maybe 5 tables and access a couple of tables where they only pull data from.
I would like to create a diagram for each area within our database. Eg.) Company profile, Housing profile, land profile

Eg.)Diagram 1:
T1 -> T2 -> T3
-> T4 -> T5

Diagram 2:
T7 -> T2 -> T3
-> T8 -> T9

Tables T2 -> T3 are used in both diagrams.

If I create more than one diagram and some tables are being used in all the diagrams, Is there anything I have to watch out for? Ex) Duplicate indexes or something like that.

Thanks
 
Nope, it'll be fine.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 
Howdy Mr.Denny,
Thanks, star to you.
It was something I always wondered about.
ksbigfoot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top