Groups | Blog | Home
all groups > sql server (alternate) > april 2005 >

sql server (alternate) : Diagram of Master DB


GM
4/21/2005 10:47:01 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
Simon Hayes
4/22/2005 1:40:37 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/techinfo/productdoc/2000/systables.asp

Simon
farrell77
4/26/2005 12:00:00 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


[quoted text, click to view]

Erland Sommarskog
4/26/2005 12:00:00 AM
farrell77 (farrell77@spamfree.yahoo.com) writes:
[quoted text, click to view]

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
AddThis Social Bookmark Button