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

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,
LindaTo 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
>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
>
>.
>

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,
LindaTo 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
> news:1d9e801c45486$4ec39d50$a301280a@.phx
.gbl...
trigger,[vbcol=seagreen]
>
>.
>

Dependent Objects

I am trying to find all the objects - SP, triggers, Views that depend on
some Table.
I was trying to use sysdepends table but it seems to me that it doesn't
return all the dependent objects. It misses obvious Update and Insert SP for
this table.
Is there a reliable way to find dependent objects.
thank you
ShimonThere is no reliable way to find dependent objects because of delayed name
resolution. However, you can try to parse syscomments :)
"Shimon Sim" wrote:

> I am trying to find all the objects - SP, triggers, Views that depend on
> some Table.
> I was trying to use sysdepends table but it seems to me that it doesn't
> return all the dependent objects. It misses obvious Update and Insert SP f
or
> this table.
> Is there a reliable way to find dependent objects.
> thank you
> Shimon
>
>