| Author |
Topic |
|
gmetaj
Starting Member
33 Posts |
 Posted - 2005-04-21 : 13:51:16
|
| Is there a way to get a Diagram of the Master DB in sql. I tried to right click on EM however the diagram option is not available as is in any ther user created DB. Any insight is greatly appreciated.ThanksGent |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-21 : 14:33:00
|
| How about the wall charts that came in the box?You do know how dangerous it is to mess with things in Master, don't you?---------------------------EmeraldCityDomains.com |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-04-21 : 15:13:48
|
| master does not contain the tables and stored procedures that a database diagram needs, so you cannot do it.CODO ERGO SUM |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-21 : 15:15:30
|
| You could also try Visio. It lets you reverse engineer into a diagram. I agree with Mark though, only do it to learn from it, not to change anything.The only thing move foolish would be rvolk washing his glasses in the dishwasher.Mike"oh, that monkey is going to pay" |
|
|
|
gmetaj
Starting Member
33 Posts |
Posted - 2005-04-21 : 15:23:56
|
I'm only doing it for learning purposes. Not really interested in doing anything specific. I was looking Information_Schema.* schema views and got curious on the whole structure of the master db and see how info about other DB is stored. So are you all saying it's basically not possible in EM? I'll give it a try to mfemenel's suggestions on VISIO.Thanks again.Gentquote:
Originally posted by AjarnMark
How about the wall charts that came in the box?You do know how dangerous it is to mess with things in Master, don't you?---------------------------EmeraldCityDomains.com
|
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-04-21 : 16:21:17
|
| Each database has it's own set of system tables that describe the user tables,views,procs etc in the database.The master database has these tables too and some other tables+views that have server wide metadata (logins for example).And msdb has the sqlserveragent + dts system tables.So you could create the schema of sysobjects,syscolumns etc. in any (user) database.the INFORMATION_SCHEMA views are interesting, and to get a diageram of those You could create physical tables of them;-- create physical snapshot of information_schema.tables view for diagramming purposesSELECT * INTO IS_TABLES FROM INFORMATION_SCHEMA.TABLESAnyway the wall charts that Mark mentioned are really nice.Is there anyplace on the net where You can download them ?rockmoose |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-21 : 18:29:02
|
| I had an electronic version of the wall charts that I got from another DBA. I'll see if I can find where they came from.---------------------------EmeraldCityDomains.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-21 : 19:07:56
|
quote:
The only thing move foolish would be rvolk washing his glasses in the dishwasher
What's so foolish about that? I wash my glasses, dishes, silverware, and all other eating utensils in the dishwasher. What the hell do you think it's supposed to be used for Femenella? Laptop keyboards???I'm scared to think what sick and twisted things you use YOUR dishwasher for.Sheesh. What a maroon. |
|
|
|
Ledell
SQL NASCAR Parsing Chick
107 Posts |
Posted - 2005-04-21 : 21:13:26
|
quote:
Originally posted by robvolk
quote:
The only thing more foolish would be rvolk washing his glasses in the dishwasher
What the hell do you think it's supposed to be used for Femenella? Laptop keyboards???
Doesn't everyone use their dishwasher to clean up their laptop keyboards? Made mine shine!*************************Got some code from Rob. Can anyone help? |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-04-22 : 02:10:09
|
| Way cool, thank You guys.Googled some, but no luck.This site is better than Google!rockmoose |
|
|
|
|
Diagram of Master DB
---------------------------