Diagram of Master DB

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

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/techin...0/systables.asp

Simon

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.googlegroups.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/techin...0/systables.asp
>
> Simon
>

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/techin.../2000/books.asp