psenn
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.