Need help with Deactivation script

Hello. I have been doing programming and stuff like that for 7 years. I am VERY good with PHP and other stuff. This is one of my first times doing any real word press development. I already have a good installation function/hook. I am trying to now write a De-activation function/hook. I have the hook working (I think) but it’s not removing the tables on uninstall. If possible, can someone review the code and give me feedback.
Thank you again for your support.

function basketball_team_analyzer_uninstall() {
	global $wpdb;

	$table_name1 = $wpdb->prefix . "wpbta_basketball_players";
	$table_name2 = $wpdb->prefix . "wpbta_basketball_teams";
	$table_name3 = $wpdb->prefix . "wpbta_basketball_teammapping";
	$table_name4 = $wpdb->prefix . "wpbta_basketball_projectedstats";
	$table_name5 = $wpdb->prefix . "wpbta_basketball_actualstats";

	$sql =  "DROP table " . $table_name1 . ";";
	$sql .= "DROP table " . $table_name2 . ";";
	$sql .= "DROP table " . $table_name3 . ";";
	$sql .= "DROP table " . $table_name4 . ";";
	$sql .= "DROP table " . $table_name5 . ";";      

      require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
	  $wpdb->query($sql);
}

// Call to create DB upon activation
register_deactivation_hook(__FILE__, 'basketball_team_analyzer_uninstall');
?>

This is not removing the database tables on uninstall.
Any help is greatly appreciated.