# Find table dependencies

**URL:** <https://forums.toadworld.com/t/find-table-dependencies/16962>\
**Category:** Toad for SQL Server\
**Created:** [July 22, 2012, 1:38am UTC](https://forums.toadworld.com/t/find-table-dependencies/16962 "2012-07-22T01:38:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DmitryGokun](https://avatars.discourse-cdn.com/v4/letter/d/e47774/32.png) [@DmitryGokun](https://forums.toadworld.com/u/DmitryGokun)\
**Post date:** [July 22, 2012, 1:38am UTC](https://forums.toadworld.com/t/find-table-dependencies/16962/1 "2012-07-22T01:38:57Z")

</div>

Hello,

i’ve just started eveluating Toad for SQL Server and have following question.

We have big database with bunch of stored procedures. All data access from applications is done via those SPs. No dynamic SQL is used in those SPs.

What i need is ability to find which SPs do INSERT to given table, which do UPDATE, which do DELETE and which do SELECT. Is that possible to do with Toad?

Best regards,  
Dmitry Gokun

---

<div class="post-metadata">

**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\
**Post date:** [July 23, 2012, 3:18am UTC](https://forums.toadworld.com/t/find-table-dependencies/16962/2 "2012-07-23T03:18:12Z")

</div>

Hello Dmitry,  
there are no such feature in TSS for right now. You can only get to know what objects have dependencies in both direction with this object. This info is displayed on Dependencies tab in Viewer.

regards,  
Alexander

---

<div class="post-metadata">

**Author:** ![DmitryGokun](https://avatars.discourse-cdn.com/v4/letter/d/e47774/32.png) [@DmitryGokun](https://forums.toadworld.com/u/DmitryGokun)\
**Post date:** [July 23, 2012, 5:18am UTC](https://forums.toadworld.com/t/find-table-dependencies/16962/3 "2012-07-23T05:18:47Z")

</div>

Hello Alexander,

thanks a lot for your answer.

It’s sad that such a useful feature is not supported though :(.

Best regards,  
Dmitry.

---

<div class="post-metadata">

**Author:** ![edwards142](https://avatars.discourse-cdn.com/v4/letter/e/919ad9/32.png) [@edwards142](https://forums.toadworld.com/u/edwards142)\
**Post date:** [September 3, 2019, 6:16am UTC](https://forums.toadworld.com/t/find-table-dependencies/16962/4 "2019-09-03T06:16:27Z")

</div>

May be this post can help you out in fixing up your finding table dependencies issue. I have not that much extent of knowledge regarding this. So, I have searched for this MS Access feature and finally got this informative post on **[MS Access Object Dependencies](http://www.accessrepairnrecovery.com/blog/fix-access-object-dependencies-not-working)**. Hopefully, you will also get some help from it.