|
Replies:
2
-
Pages:
1
-
Last Post:
Jul 23, 2012 3:18 AM
by: Dmitry Gokun
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
2
Registered:
7/21/12
|
|
|
|
Find table dependencies
Posted:
Jul 21, 2012 11:38 PM
|
|
|
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
|
|
|
Posts:
794
Registered:
6/16/10
|
|
|
|
Re: Find table dependencies
Posted:
Jul 23, 2012 1:18 AM
in response to: Dmitry Gokun
|
|
|
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
|
Alexander Maximov, DELL
|
|
Posts:
2
Registered:
7/21/12
|
|
|
|
Re: Find table dependencies
Posted:
Jul 23, 2012 3:18 AM
in response to: Alexander.Maximov
|
|
|
Hello Alexander,
thanks a lot for your answer.
It's sad that such a useful feature is not supported though  .
Best regards,
Dmitry.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
