DML operation on a table [message #678775] |
Fri, 10 January 2020 00:27 |
|
deepakdot
Messages: 91 Registered: July 2015
|
Member |
|
|
I want to find out all the table list , on which some INSERT / UPDATE / DELETE occur.
Here is the scenario. we are getting hundreds of scripts which contain INSERT / UPDATE / DELETE. lets say to 50 tables. I want to know which are those 50 tables affected with the script. we might have 200 tables in the database, But I am interested to know only these 50 tables.
I can create 200 triggers for each table, If any DML operation happen on any table, I can insert to a temp table, with the table name. But creating trigger for 200 tables may not be a good idea. Any other easy way we can find out those 50 tables ? I can execute all these scritps in a schema and then want to capture these 50 tables. .
Deepak
|
|
|
|
|