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;