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.
| Author |
Topic |
|
pssheba
Yak Posting Veteran
95 Posts |
 Posted - 2008-04-27 : 07:53:41
|
| it is attributed ?Hi everyone,My table contains columns that are goreign keys to other tables. How can i tell to which table/column each fk is attributed ?Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-27 : 10:07:33
|
have a look at INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
elsasoft.org |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-27 : 10:36:12
|
| you can also run sp_help <yourtable> to get details on foreign key constraints on your table. |
|
|
|
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2008-04-28 : 02:09:10
|
| Thanks a lot ! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-28 : 02:19:11
|
quote:
Originally posted by pssheba
Thanks a lot !
You're welcome  |
|
|
|
|
|
|
foreign kew, how do i get to know to which table