Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ThreePea
Yak Posting Veteran
83 Posts |
 Posted - 2003-12-12 : 10:24:35
|
| Hey everyone.Is there a system table or column flag somewhere in SQL Server 2000 which tells me which tables are part of a diagram? I've searched BOL, SQLTeam, and other avenues and either there is no information on this, or I have missed it. This link looked promising, [url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=5221[/url], but swynk.com is no more, so I couldn't find the page it linked to.The reason for this is that we have a strict standard that all tables must be on a diagram, and I've been asked if there is an easy way to determine which tables are not.Thanks.3P==================================================Tolerance is the last virtue of an immoral society. -- G.K. Chesterton |
|
|
ThreePea
Yak Posting Veteran
83 Posts |
Posted - 2003-12-12 : 10:33:11
|
| For those that just need to transfer a diagram from one SQL Server instance to another, I did find the following link:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125Doesn't help me, but it might help anyone looking for the original swynk article.3P==================================================Tolerance is the last virtue of an immoral society. -- G.K. Chesterton |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-12 : 12:26:33
|
| Diagrams are stored in the dtproperties table. This table will not give any information about which tables are stored in your diagram. I do not believe that there is a system table that does this. You will have to open up the diagram and manually check for things.Tara |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-12-12 : 12:41:40
|
| And I thought that KB entry should probably be linked to on the site.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
|
|
Script to find tables not in a diagram?