key relationships - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

key relationships

Author

Topic

collinsca
Starting Member

23 Posts

Posted - 2007-06-01 : 10:25:51

I am viewing tables in the ‘object explorer’- I can see the tables. If I open it up I can see columns, keys, constraints etc…

So I can see they key… can I tell which table/field the foreign key is connected to?

thanks

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2007-06-01 : 10:51:26

Double-click the key to open the "Foreign Key Relationships" dialog.

Mark

collinsca
Starting Member

23 Posts

Posted - 2007-06-02 : 06:31:12

thanks my friend

collinsca
Starting Member

23 Posts

Posted - 2007-06-04 : 03:04:28

I have just tried it.

The box you mentions comes up- but i cant see where the foreign key is linked to....

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2007-06-04 : 04:31:38

You should be able to expand the "Tables and Columns Specification" to see this.

Mark

collinsca
Starting Member

23 Posts

Posted - 2007-06-04 : 06:40:47

thanks

How would I tell the relationship of a primary key- by viewing the primary key?

Can I only identify the relationship to a primary key by investigating the foreign keys?

thanks

collinsca
Starting Member

23 Posts

Posted - 2007-06-13 : 03:42:11

anyone... please?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-13 : 11:17:27

You can script the key to see details.

collinsca
Starting Member

23 Posts

Posted - 2007-06-14 : 03:15:35

thanks.
thing is- im so inexperienced- i wont know what it is telling me- and where i am looking. ( i amd ocumenting somenoe else's db).