472,811 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,811 software developers and data experts.

Diagram of Master DB

GM
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

Jul 23 '05 #1
3 2794
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

Jul 23 '05 #2
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" <sq*@hayes.ch> wrote in message
news:11*********************@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

Jul 23 '05 #3
farrell77 (fa*******@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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tim Smith | last post by:
Dear All, Silly question, but I am having trouble understanding the diagram on the inside back cover entitled "Design Pattern Relationships." It shows the relationships between all of the...
1
by: Maria | last post by:
Heya, I am doing some background reading about the database and i am a little bit confused, i would appreciated any help.... Assume been asked to draw the ER diagram for the following...
4
by: PIEBALD | last post by:
I'm trying to find a general definition/specification for railroad diagrams. All I find online are explanations by authors who explain what _their_ particular format uses, but they leave me...
3
by: Terry | last post by:
I have added some tables to the MS Access relationship diagram window (2003) and added some relationships. But after a while when I reopen the diagram some of the tables are hidden above the top of...
2
by: sangu_rao | last post by:
Hi, I have to prepare an ER diagram for the objects in my SQL Server database. I have used the option "DIAGRAMS" in EnterPrise Manager of SQL Server 2000. It is creating the diagram for the...
70
by: Anson.Stuggart | last post by:
I'm designing a debounce filter using Finite State Machine. The FSM behavior is it follows the inital input bit and thinks that's real output until it receives 3 consecutive same bits and it...
1
by: Oskar Bennet | last post by:
Hi everybody, I am supposed to draw a simple UML diagram for a very small project that consists of less than a dozen classes. I have never been working with UML before, I have read some tutorials...
13
by: Doug | last post by:
Hi all, A workmate was recently bitching to me about an RFC. (Apologies - the RFC number eludes me at present (it's related to the DIAMETER protocol, that's all I can remember) but I will try...
0
by: viepia | last post by:
Hi, My project writes records to a new SQL Server 2005 database with currently 18 tables. When I change the Database Diagram for my database I save the copy the list of changed tables to a...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.