#!/usr/bin/perl
use warnings;
use 5.012;
use DBI;

my $host = 'hostname';
my $port = 2000;
my $db = 'db1.mdb';
my $dsn = "DBI:ODBC:$db";
my $dsn = "DBI:Proxy:hostname=$host;port=$port;dsn=$dsn";
my $dbh = DBI->connect( $dsn, undef, undef, { RaiseError => 1, PrintError => 0 } ) or die $DBI::errstr;

my $table = 'my_test_table';

my $sql = "DROP TABLE $table";

### 1
do { local $dbh->{RaiseError} = 0; $dbh->do( $sql ); };

### 2
if ( $table ~~ @{[ $dbh->tables() ]} ) {
        $dbh->do( $sql );
}

### 3
eval{ $dbh->do( $sql ); };

##################################