March 27, 2013 at 6:43 am
Does a database diagram exist of SQL Server's system tables?
I am looking for documentation that will show me on which columns to join system tables so that I can develop my own investigative queries. I am familiar with many helpful posts that provide queries....however, invariably they require me to rely on someone else's experience to identify the keys on which to join tables and that that the joins are correct. SQL Server documentation of system tables, similar to http://msdn.microsoft.com/en-us/library/ms187997.aspx, but showing mapping between system tables, where primary keys are identified is what I'm looking for.
--Quote me
March 27, 2013 at 6:51 am
This is the closest thing I have found over the past few years. MS has shied away from promoting the true system tables so people don't code against them instead promoting the system views.
March 27, 2013 at 2:00 pm
OK, thank you very much.
March 27, 2013 at 2:54 pm
SCH70 (3/27/2013)
http://www.microsoft.com/en-us/download/details.aspx?id=722%5B/quote%5D
Let us make it easy for others: http://www.microsoft.com/en-us/download/details.aspx?id=722
March 27, 2013 at 3:08 pm
Better yet, Lynn, if you have a diagram that contains views and how they're related to system tables, post it!
March 27, 2013 at 3:09 pm
KoldCoffee (3/27/2013)
Better yet, Lynn, if you have a diagram that contains views and how they're related to system tables, post it!
Nope, sorry or I would.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply