Posted by Hugo Kornelis on 10/28/06 22:12

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

>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

[Back to original message]