Generate Schema

#1

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

#2

Expand the database in Object Explorer, right-click the "Database Diagram" folder, "New Database
Diagram".

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"toney" <toney (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#3

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:

Quote:

You can also use Generate Script. In SSMS, right click on a database,
Tasks\Generate Scripts...

--
Ekrem Önsoy

"toney" <toney (AT) discussions (DOT) microsoft.com> wrote in message
news

EF49EE6-73D2-4251-AEDB-AF861B39E928 (AT) microsoft (DOT) 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

#4

It doesn't. Schema can mean many things (an overloaded term) and Ekrem probably missed the
"graphical representation" part of your question.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"toney" <toney (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news

EF49EE6-73D2-4251-AEDB-AF861B39E928 (AT) microsoft (DOT) 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

#5

On Nov 8, 5:02 pm, toney <to... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Generate Schema

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Generate Schema - 11-08-2007 , 07:02 PM

Re: Generate Schema - 11-09-2007 , 02:09 AM

Re: Generate Schema - 11-12-2007 , 11:44 AM

Re: Generate Schema - 11-12-2007 , 12:06 PM

Re: Generate Schema - 11-13-2007 , 03:16 PM