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?
--
ChloeFrom 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|||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
> 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...
> > > Hi, I am trying to view the relationship data in a sql server 2000
> > database.
> > > How do I go about this?
> > > --
> > > Chloe
> >
> >
> >