dependent tables

How can I find out all dependent tables to a table?
I don't see this information in sysdepends, sysdepends
provides information about dependent procedure, trigger,
views.
Thank you,
Linda
To show all tables with foreign keys to pubs..titles:
use pubs
select object_name(fkeyid)
from sysforeignkeys
where rkeyid=object_id('titles')
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:1d9e801c45486$4ec39d50$a301280a@.phx.gbl...
> How can I find out all dependent tables to a table?
> I don't see this information in sysdepends, sysdepends
> provides information about dependent procedure, trigger,
> views.
> Thank you,
> Linda
|||Thank you Adams, this is what I was looking for.
-Linda
>--Original Message--
>To show all tables with foreign keys to pubs..titles:
>use pubs
>select object_name(fkeyid)
>from sysforeignkeys
>where rkeyid=object_id('titles')
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1d9e801c45486$4ec39d50$a301280a@.phx.gbl...
trigger,
>
>.
>