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 |
|
nabajyoti
Starting Member
3 Posts |
 Posted - 2008-01-24 : 07:10:55
|
| i want to create a relationship diagram for the sql tables in sql server 2000how do i create that? |
|
|
crever
Starting Member
7 Posts |
Posted - 2008-01-24 : 10:27:10
|
| A couple ways will get you what you want. 1. You can use a 3rd party tool like ERStudio. It's an excellent tool. There are many more 3rd party tools though so look around, but I highly recommend ERStudio. http://www.embarcadero.com/products/erstudio/index.html2. SQL has a built-in diagram tool. You can find it in your database tree in Ent. Mgr under database diagram. Just right-click and you can choose the tables to add to it. It's basic and I'm not that fond of it, but it'll give you a starting point. |
 |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-25 : 01:05:02
|
| ER Studio is nice. And well priced. If you have Visio you can Reverse Engineer from there as well. I perfer ErWin over ER Studio because you can chose to get a repository with the tool that will allow you to manage who can use the diagrams.Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
relationship diagram