Rename Drupal Tables (remove prefix)

rename-tables.php

<?php

$cn = \Drupal\Core\Database\Database::getConnection('default', 'default');

// This is prefix you want your tables to remove.
$prefix = 's3cr3t_';

// Read all tables
$result = $cn->query("SHOW TABLES");

if ($result) {
  while ($row = $result->fetch(PDO::FETCH_NUM)) {
    // rename table
    $table_old = $row[0];
    $table_new = str_replace($prefix, '', $table_old);
    $cn->query("RENAME TABLE {$table_old} TO {$table_new}");
    // show progress
    print "  $table_old -> $table_new\n";
  }
}