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
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