Listing all the models(tables) used in a controller

Hi Folks,
When ever action is performed in from the browser, i
want to list the number of tables that are getting affected due to
that action along with or without the table level constraints.

Any information on this regard will help.

Regards,
Syed A B.