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 |
|
fguihen
Starting Member
1 Post |
 Posted - 2004-04-16 : 09:41:50
|
| theres a rather large DB system on a server where i work. i have to link it to another large server DB. the prob is that theres no documentation or diagrams on what tables are related and what columns are for. are there any programs/qwueries that i can run on a DB that will allow me to see what columns in what tables are related?( i dont want to have to trawl through the DB to find out all this info) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-16 : 11:29:11
|
| Got ERWin? Visio 2000 Pro? Can you script the database?Brett8-) |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-04-16 : 12:49:03
|
| Open up EM, Do a "New Diagram" and add all of the non-system tables.ERWin or Visio would do a better job methinks, but if you don't have those, try my solution.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-16 : 12:50:28
|
| You can also use the INFORMATION_SCHEMA views to see the information in a table format. I would recommend using Enterprise Manager as Michael mentioned if you don't have the other powerful tools like Brett mentioned.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-16 : 13:34:32
|
| Ya know...I WAS going to do something...No good INFORMATION_SCHEMA...OK, looked at sp_help...what a mess..Then looked at the sp_Constraints that it calls...Cursors, temp tables, Foreign key data displayed over 2 non keyed rows...what a mess....Go buy visio...or script the database, place all of the code in to a table and then mine that dataBrett8-) |
|
|
|
|
|
|
finding related tables in large DB