Join of System Tables

• mannu_leo

  SSChasing Mays

  Points: 614

  More actions

  September 13, 2003 at 5:36 am

  #82944

  How we can create relationship schema b/w

  all system tables

• mccork

  SSC-Insane

  Points: 22288

  More actions

  September 13, 2003 at 5:51 am

  #474045

  Are you after a map of all the system tables?

  Microsoft produces a hardcopy schema that you can put up on the wall. Don't put it up near an Oracle map though, otherwise your Oracle DBA will look 3 times cleverer than you.

  There's a very good softcopy map (systbl.chm) available at http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

  Cheers,

  - Mark

  Edited by - mccork on 09/13/2003 05:52:00 AM

  
  Cheers,
  - Mark

• mannu_leo

  SSChasing Mays

  Points: 614

  More actions

  September 13, 2003 at 5:57 am

  #474047

  Thanx Mccork

  It solves my problem

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  September 13, 2003 at 10:59 am

  #474060

  I think Andy Warren has some hard copies. Send him an email and he might be able to get you one (awarren@sqlservercentral.com)

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net

• Sammoayedi

  SSC-Addicted

  Points: 426

  More actions

  January 17, 2006 at 3:24 am

  #615079

  Could you please let me the new link for sysytem tables(SQL 2000) since it has been removed from MS site

  Thanks