| Author |
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
| |
|
|
| farrell77 2005-04-26, 8:23 pm |
| 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
>
| |
| Erland Sommarskog 2005-04-26, 8:23 pm |
| 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
|
|
|
|