Select Code to Download

my $query =  "IF EXISTS(SELECT * FROM sys.tables WHERE type = 'U' AND 
+name = '$table_name')
    SELECT 1 ELSE SELECT 0";
my $sth = $dbh->prepare( $query );
$sth->execute;
my $result = $sth->fetchrow_array;