figuring out a large DB

• winston Smith

  SSCoach

  Points: 19500

  More actions

  April 16, 2004 at 9:47 am

  #84805

  ok, i have a large Db, and no documentation or diagrams. how do i figure out what each column is for? is there any way i can track where data is being stored in the DB? i have to find out what tables are linked , but have no diagrams. any ideas?. if i click on create new diagram and import all teh tables, it doesnt show any relationships

• Darrell Zink

  SSC Enthusiast

  Points: 187

  More actions

  April 17, 2004 at 11:21 am

  #503249

  sysforeignkeys contains all foreign key information for a database.

  sp_fkeys displays FK information for a given table.

  A variety of information is available using the Information_Schema views associated with each database.