Is there a module that lists which tables are created, owned or modified by a particular module? Is there a module that lists which tables are created, owned or modified by a particular module?

I need something that can show me what tables are created or modified by when new modules are installed.
Since Drupal 7, tables should get created by modules using hook_schema(), because these tables will also get removed when uninstalling the module. 

You can find these tables by executing the code below, or by using the Schema module (https://drupal.org/project/schema):

$schema = drupal_get_schema(Null,TRUE);// Get List Of all tables. 
  ksort($schema);// Sort Ascending
  foreach($schema as $table =&gt; $value){
    print_r($table."&lt;br&gt;");
  } 


All well written modules should create tables only using hook_schema, and should not alter tables in other modules. 

If you suspect that other tables got changed, you can find this in the .install file for each module. Look for the database layer calls like db_add_field or even db_create_table. 

For a list of all these, consult the Drupal documentation:
https://api.drupal.org/api/drupal/includes!database!database.inc/