Newbie Question

How can you create a relationship between two tables in two different databases? Or can you?
Thanks... Sorry if it is a simple question..You can't create cross database RI...

You'll need to use triggers...

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
>
>

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
> >
> >
> >

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|||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 t
o
> 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
>
>sql

Newbie Entity Relationship Advice

Dear All,
Firstly since the first time posting on this group, I apologise if this is
posted on the wrong newsgroup but could someone please help me with the
question below.
I have received a database designed by a colleague who has since left the
organisation and I was wondering if there were any tools or techniques that
could help create an entity relationship diagram of the database. With Acces
s
you had a utility called database documentor, which could help me with my
task. If this is not possible I would like to get a list of all tables and
Primary/Foreign key constraints.
There are over 100 tables and it would take a long time to go through each
one looking at primary keys and foreign keys. Is there anyone out there that
can offer this SQL Server 2000 newbie some helping advice?
p.s. What newsgroup should I have posted a general question on?
Thanks.
Alastair MacFarlaneYes. You can do this in SQL Server 2000. Look in the Database and you will
see a "Diagrams" icon. Use that to create the entity relationship.
"Alastair MacFarlane" <AlastairMacFarlane@.discussions.microsoft.com> wrote
in message news:477DE3D1-0457-4AF3-B067-BA5A880364F0@.microsoft.com...
> Dear All,
> Firstly since the first time posting on this group, I apologise if this is
> posted on the wrong newsgroup but could someone please help me with the
> question below.
> I have received a database designed by a colleague who has since left the
> organisation and I was wondering if there were any tools or techniques
> that
> could help create an entity relationship diagram of the database. With
> Access
> you had a utility called database documentor, which could help me with my
> task. If this is not possible I would like to get a list of all tables
> and
> Primary/Foreign key constraints.
> There are over 100 tables and it would take a long time to go through each
> one looking at primary keys and foreign keys. Is there anyone out there
> that
> can offer this SQL Server 2000 newbie some helping advice?
> p.s. What newsgroup should I have posted a general question on?
> Thanks.
> Alastair MacFarlane|||The Database Diagram tool within Enterprise Manager allows you to create a
visual diagram of the database that can also be used to create, edit or
delete tables. You can launch the wizard by right-cling on the Diagrams
node under the desired database and selecting 'new database diagram'. See
the Books Online for details on usage.
Hope this helps.
Dan Guzman
SQL Server MVP
"Alastair MacFarlane" <AlastairMacFarlane@.discussions.microsoft.com> wrote
in message news:477DE3D1-0457-4AF3-B067-BA5A880364F0@.microsoft.com...
> Dear All,
> Firstly since the first time posting on this group, I apologise if this is
> posted on the wrong newsgroup but could someone please help me with the
> question below.
> I have received a database designed by a colleague who has since left the
> organisation and I was wondering if there were any tools or techniques
> that
> could help create an entity relationship diagram of the database. With
> Access
> you had a utility called database documentor, which could help me with my
> task. If this is not possible I would like to get a list of all tables
> and
> Primary/Foreign key constraints.
> There are over 100 tables and it would take a long time to go through each
> one looking at primary keys and foreign keys. Is there anyone out there
> that
> can offer this SQL Server 2000 newbie some helping advice?
> p.s. What newsgroup should I have posted a general question on?
> Thanks.
> Alastair MacFarlane|||With SQL Server, create a DB diagram via Enterprise manager by selecting all
the tables. This will get u the ERD along with all existing relationships...
R
"Alastair MacFarlane" wrote:

> Dear All,
> Firstly since the first time posting on this group, I apologise if this is
> posted on the wrong newsgroup but could someone please help me with the
> question below.
> I have received a database designed by a colleague who has since left the
> organisation and I was wondering if there were any tools or techniques tha
t
> could help create an entity relationship diagram of the database. With Acc
ess
> you had a utility called database documentor, which could help me with my
> task. If this is not possible I would like to get a list of all tables an
d
> Primary/Foreign key constraints.
> There are over 100 tables and it would take a long time to go through each
> one looking at primary keys and foreign keys. Is there anyone out there th
at
> can offer this SQL Server 2000 newbie some helping advice?
> p.s. What newsgroup should I have posted a general question on?
> Thanks.
> Alastair MacFarlane|||Thanks Yosh, Dan and Rakesh. I didn't realise that the wizard would create
the entity diagram for you. This is better that Access!
Alastair
"Yosh" wrote:

> Yes. You can do this in SQL Server 2000. Look in the Database and you will
> see a "Diagrams" icon. Use that to create the entity relationship.
>
> "Alastair MacFarlane" <AlastairMacFarlane@.discussions.microsoft.com> wrote
> in message news:477DE3D1-0457-4AF3-B067-BA5A880364F0@.microsoft.com...
>
>|||The Diagram will automatically draw connecting lines only if referential
integrity constraints were implemented on the tables.
"Yosh" <Yosh@.nospam.com> wrote in message
news:u3iMO5irFHA.3788@.TK2MSFTNGP12.phx.gbl...
> Yes. You can do this in SQL Server 2000. Look in the Database and you will
> see a "Diagrams" icon. Use that to create the entity relationship.
>
> "Alastair MacFarlane" <AlastairMacFarlane@.discussions.microsoft.com> wrote
> in message news:477DE3D1-0457-4AF3-B067-BA5A880364F0@.microsoft.com...
>