Generate Schema

Hello, how do I generate a schema of a database in sql server 2005? I want to
see a graphic representation of all the table and fields, what the primary
keys are, relathionships, and so forth.
thanks
toney
You can also use Generate Script. In SSMS, right click on a database,
Tasks\Generate Scripts...
Ekrem ?nsoy
"toney" <toney@.discussions.microsoft.com> wrote in message
news:DEF49EE6-73D2-4251-AEDB-AF861B39E928@.microsoft.com...
> Hello, how do I generate a schema of a database in sql server 2005? I want
> to
> see a graphic representation of all the table and fields, what the primary
> keys are, relathionships, and so forth.
> thanks
> --
> toney
>
|||Ekrem, how would the Generate Scripts wizard generate a visual
reporesentation of the structure of the DB? I see how it creates samples code.
toney
"Ekrem ?nsoy" wrote:

> You can also use Generate Script. In SSMS, right click on a database,
> Tasks\Generate Scripts...
> --
> Ekrem ?nsoy
>
> "toney" <toney@.discussions.microsoft.com> wrote in message
> news:DEF49EE6-73D2-4251-AEDB-AF861B39E928@.microsoft.com...
>
|||On Nov 8, 5:02 pm, toney <to...@.discussions.microsoft.com> wrote:
> Hello, how do Igeneratea schema of a database insqlserver 2005? I want to
> see a graphic representation of all the table and fields, what the primary
> keys are, relathionships, and so forth.
> thanks
> --
> toney
You can create a database diagram to show relationships. if you
expand the database node in OE, you'll see a "database diagrams"
folder. right click on that to create a diagram.
also you might find this tool useful: http://www.elsasoft.org