<?php
// Deleting the table whenever a blog is deleted
function on_delete_blog( $tables ) {
    global $wpdb;
    $tables[] = $wpdb->prefix . 'table_name';
    return $tables;
}
add_filter( 'wpmu_drop_tables', 'on_delete_blog' );
?>