• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 141
  • Last Modified:

Getting to know you sql server 2000 data

I need to get acquanted with a new database that I just inherited.  It has 29 tables, and it looks like a good sampling of indexes.
Q: How do you go about getting familiar with a database, other than just stepping down through each table one at a time?  There's no database diagram and every table has a primary key called "pkey".

Oh!  And it's a SQL Server 2000 database.
0
psenn
Asked:
psenn
1 Solution
 
lahousdenCommented:
If the database has been blessed by its creator with declarative constraints then you will be off to a running start - you can examine these to see what the relationships are.  If, further, you have Microsoft Visio Professional then you are doubly blessed, since you will be able to reverse engineer a Data Model diagram from the declarative constraints in the physical database.
0
 
psennAuthor Commented:
Alas, I am not so blessed.
I ran a profiler and all the queries seem to be coming back fine.
I did a search through all the source code for the phrase "<space>on<space>" to determine relationships.
If found some, but not everything.
In all, I'd say it's not written too badly.
I just need to grok it.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now