SEO

#1 (**permalink**) 02-29-2008, 07:09 AM

Is there a way to get the diagram of the MASTER Db in MS-SQL? When i
right click on Enterprise Manager that option is not available but it
is available in any other database (Model Db acts the same).

Thanks,

Gent

#2 (**permalink**) 02-29-2008, 07:10 AM

I don't know why that option is disabled for system DBs, but you can
get a full diagram of all the system tables here:

http://www.microsoft.com/sql/techinf.../systables.asp

Simon

#3 (**permalink**) 02-29-2008, 07:13 AM

I'm new here. Sorry if this has already been covered. Is there a way to
generate full diagrams for the tables you create? Thanks.

- Bob

"Simon Hayes" <sql@hayes.ch> wrote in message
news:1114159237.222700.21110@g14g2000cwa.googlegro ups.com...
> I don't know why that option is disabled for system DBs, but you can
> get a full diagram of all the system tables here:
>
> http://www.microsoft.com/sql/techinf.../systables.asp
>
> Simon
>

#4 (**permalink**) 02-29-2008, 07:13 AM

farrell77 (farrell77@spamfree.yahoo.com) writes:
> I'm new here. Sorry if this has already been covered. Is there a way to
> generate full diagrams for the tables you create? Thanks.

You can generate diagrams of your database from Enterprise Manager.
Right-click your database and select New->Database diagram.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

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

SEO

Diagram of Master DB