drupal_module__reinstall/reinstall.install

<?php

/**
 * Remove migration tables.
 *
 * @param $table
 */
function reinstall_remove_migration_tables($table) {
  $db = \Drupal::database();
  $logger = \Drupal::logger('reinstall');

  $db->schema()->dropTable('migrate_map_' . $table);
  $logger->notice('Table migrate_map_@table dropped', [
      '@table' => $table,
  ]);

  $db->schema()->dropTable('migrate_message_' . $table);
  $logger->notice('Table migrate_message_@table dropped', [
      '@table' => $table,
  ]);
}

/**
 * Implements hook_uninstall.
 */
function reinstall_uninstall() {
  // Get all migrations.
  $manager = \Drupal::service('plugin.manager.config_entity_migration');
  $plugins = $manager->createInstances([]);

  // Remove migration tables.
  foreach ($plugins as $migration) {
    reinstall_remove_migration_tables($migration->id());
  }
}