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.

 All Forums
 Development Tools
 ASP.NET
 datamodel

Author  Topic 

notsosuper
Posting Yak Master

190 Posts

Posted - 2005-05-27 : 13:10:07
How can I obtain datamodel from my database, so I can see all the relationships between tables?

jhermiz

3564 Posts

Posted - 2005-05-27 : 13:14:47
Go into enterprise manager and click your database. One of the options you hav ewithin tables, stored procedures, etc is diagram. Go into that and create a diagram.



Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

notsosuper
Posting Yak Master

190 Posts

Posted - 2005-05-27 : 14:54:36
Actually I think diagram exist somewhere, because it has been printed before.
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-05-27 : 17:04:30
Well then, it will either be in the Diagrams section of the database, or it was created in a modeling tool like Visio, ER/Studio, etc. Better check with the rest of the staff to see if they know where it is.

---------------------------
EmeraldCityDomains.com
Go to Top of Page
   

- Advertisement -