Database Relationship

Hi all,
Where can I see the Table relationship in Enterprise Manager. I see all
Tables but to run some query using two or more tables I need to know which
table is connected with that particular table. Can someone help me.
Thanks,
BetreTwo ways, and they only work if there is actually a defined relationship.
1. Look in the diagrams, or create a new one with the tables in question.
Anything you do here as far as adding/deleting may affect the actual table.
Its not just a picture...
2. Create a new view and add the tables. If the relationship has been
defined, it will fill in automatically
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:1F84DE39-7EC6-4DA7-937B-0F8D8EDC90E9@.microsoft.com...
> Hi all,
> Where can I see the Table relationship in Enterprise Manager. I see all
> Tables but to run some query using two or more tables I need to know which
> table is connected with that particular table. Can someone help me.
> Thanks,
> Betre|||Also, you can right click on tables and look at the design. Then right
click on columns and check out relationships, keys, indexes, etc.
Kevin3NF wrote:
> Two ways, and they only work if there is actually a defined relationship.
> 1. Look in the diagrams, or create a new one with the tables in question.
> Anything you do here as far as adding/deleting may affect the actual table.
> Its not just a picture...
> 2. Create a new view and add the tables. If the relationship has been
> defined, it will fill in automatically
>
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:1F84DE39-7EC6-4DA7-937B-0F8D8EDC90E9@.microsoft.com...
> > Hi all,
> >
> > Where can I see the Table relationship in Enterprise Manager. I see all
> > Tables but to run some query using two or more tables I need to know which
> > table is connected with that particular table. Can someone help me.
> >
> > Thanks,
> >
> > Betre