newbie q - viewing relationships in SQL Server 2000

Hi, I am trying to view the relationship data in a sql server 2000 database.
How do I go about this?
Chloe
From query analyzer you can do
sp_help tablename or
sp_helpconstraint tablename
From SQL Enterprise Manager select the database, select tables, and on the
right side you may right click on a table.
There is also an information_schema view which allows you to get at the
relationships, but I forget the name ... Search for information_schema in
books on line.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Chloe" <Chloe@.discussions.microsoft.com> wrote in message
news:E15CAC20-6FC8-4E03-AFBF-4F6F0023417A@.microsoft.com...
> Hi, I am trying to view the relationship data in a sql server 2000
database.
> How do I go about this?
> --
> Chloe
|||Thanks for that. I am wondering though, is there a way to view the
relationships that are set up, similar to the way you can view it in access
for instance?
"Wayne Snyder" wrote:

> From query analyzer you can do
> sp_help tablename or
> sp_helpconstraint tablename
> From SQL Enterprise Manager select the database, select tables, and on the
> right side you may right click on a table.
> There is also an information_schema view which allows you to get at the
> relationships, but I forget the name ... Search for information_schema in
> books on line.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Chloe" <Chloe@.discussions.microsoft.com> wrote in message
> news:E15CAC20-6FC8-4E03-AFBF-4F6F0023417A@.microsoft.com...
> database.
>
>
|||In Enterprise manager you can make a diagram and when you add the tables to
it relationships will be shown graphically.
Bojidar Alexandrov
"Chloe" <Chloe@.discussions.microsoft.com> wrote in message
news:7CBA3CFD-3114-4D19-A4A1-B44B497CF656@.microsoft.com...
> Thanks for that. I am wondering though, is there a way to view the
> relationships that are set up, similar to the way you can view it in
access[vbcol=seagreen]
> for instance?
>
> "Wayne Snyder" wrote:
the[vbcol=seagreen]
in[vbcol=seagreen]
|||Thanks for that.
"Bojidar Alexandrov" wrote:

> In Enterprise manager you can make a diagram and when you add the tables to
> it relationships will be shown graphically.
> Bojidar Alexandrov
>
> "Chloe" <Chloe@.discussions.microsoft.com> wrote in message
> news:7CBA3CFD-3114-4D19-A4A1-B44B497CF656@.microsoft.com...
> access
> the
> in
>
>