my $database = DBI->connect("DBI:mysql:database_name,'user','pw')
  or die "Could not connect to database: " . DBI->errstr;

##</code><code>##

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();