Retrieving table information from a database

[cREbralFIX]

Hi all,

I'm using Perl, DBI, and the ODBC driver on Windows with MySQL 4.1.9. I am writing a DB creation script want to test for the existence of a table. I've tracked down the table_info and table functions (and TABLE_NAME attribute) in perldoc DBI. However, it seems I cannot use the information returned. How do I test for a table in a database?

I'm looking at something like:

my $table = "this_isa_name";
my $result = $dbh -> table_info ( '','',$table, '');

if ( $result ) {
print "table $table exists\n";
} else {
print "nope, ain't there!\n";
}

Thanks!