Getting to know you sql server 2000 data

Posted on 2007-08-06
Last Modified: 2013-11-05
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.
Question by:psenn
    LVL 10

    Accepted Solution

    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.

    Author Comment

    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.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now