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 |
|
richardlaw
Yak Posting Veteran
68 Posts |
 Posted - 2009-01-16 : 11:37:09
|
| HiI'm fairly new to MS SQL 2005. I've now got a database up and running with a number of tables and views each with relationships.Is there a visual tool I can used to see a high level view of what tables I have and how they are related?Many thanksRichardRichard Law |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-16 : 12:13:02
|
| In SQL Mgmnt studio, you can expand your database and tables to see all tables in explorer on left side. then you can click database diagrams and select new db diagram. then window opens up where you can drag and drop the tables. right click and select show relationships,then you can see relationships between tables. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 14:55:24
|
| You can use sp_depends for views and SP. |
|
|
|
|
|
|
How best to view table relationships