database analysis

hello!

i'm looking for resources on database analysis. my main questions are:
how does one determine the primary key of a table, and, how does one
determine the relationships between the tables?

if you know of any tips, books or websites, i'd love to know. my
current skills for such quests are mainly looking at field names and
data and trying to figure out visio. if there are better approaches,
i'd love to learn.

thanks,

-jOn 26 Oct 2006 12:58:04 -0700, joeyp wrote:

Quote:

Originally Posted by

>hello!
>
>i'm looking for resources on database analysis. my main questions are:
>how does one determine the primary key of a table, and, how does one
>determine the relationships between the tables?
>
>if you know of any tips, books or websites, i'd love to know. my
>current skills for such quests are mainly looking at field names and
>data and trying to figure out visio. if there are better approaches,
>i'd love to learn.
>
>thanks,
>
>-j

Hi j,

If you're using SQL Server 2005, then search Books Online for "Object
Catalog Views", or check out the various INFORMATION_SCHEMA views.

For SQL Server 2000, check out the INFORMATION_SCHEMA views or the
system tables, also in Books Online.

--
Hugo Kornelis, SQL Server MVP