WordPress - Replace Table Prefixes

replace_table_prefixes.php

<?php
/**
 * Replace and rename table prefixes
 *
 * @param string $old The old table prefix to be replaced.
 * @param string $new The new table prefix.
 * @author Travis Aaron Wagner
 */
function taw_replace_table_prefixes( $old, $new ) {
	global $wpdb;
	$sql_get_tables = "SHOW TABLES LIKE '$old%'";
	$bad_tables = $wpdb->get_results( $sql_get_tables );

	if ( empty( $bad_tables ) ) {
		return;
	}

	foreach ( $bad_tables as $table ) {
		foreach ( $table as $key => $name ) {
			$new_name = str_replace( $old, $new, $name );
			$sql = "ALTER TABLE $name RENAME TO $new_name";
			try {
				$wpdb->query( $sql );
			} catch ( Exception $e ) {
				echo 'Caught exception: ' . esc_html( $e->getMessage() );
			}
		}
	}
}
add_action(
	'init',
	function() {
		global $wpdb;
		taw_replace_table_prefixes( 'dcl_', $wpdb->prefix );
	}
);