my $script = "DROP TABLE your_tablename ";

my $sql = $database->prepare_cached($script)
  || die "Couldn't prepare SQL: " . $database->errstr;

$sql->execute()
  || die "Can't execute SQL: " . $database->errstr;
$sql->finish();