Helper script to drop a bunch of imported tables from a WP test site.

drop-db-tables.wp.php

<?php
/**
 * Drop a bunch of tables.
 *
 * Update the prefix in the foreach definition then run via WP-CLI,
 * ie "wp eval-file ../path/to/this-script.php".
 */
global $wpdb;

foreach ( $wpdb->get_col( "SHOW TABLES LIKE 'customer_db_%'" ) as $table ) {
	$wpdb->query( $wpdb->prepare( 'DROP TABLE %s', $table ) );
}