How to Know what tables get affected for a given process??
Posted on 2003-12-01
Is there any command or any setting that I have to do so that I know what tables are being accessed for a given process?
I have a set of processes that run against the Sybase database and Select/Update/Insert various tables. I want to know what all tables are being accessed for a particular process.
Suppose I run the Payments process, this will select from a table called tbl_invoice etc,
and Insert/Update tbl_payment etc.
I want to get the list of all the tables that this process accesses, i.e what are the tables that it Selects, what tables does it Inserts into and what are thte tables that this will Update.
Is there any setting which I can set and then run the Payamnet process so that at the end of the process I have the above said list. Something similar to profiler.
Thanks in advance,