MySQL in a Nutshell

Name

table_info( )

Synopsis

$database_handle->table_info($catalog, $schema, $table, 
                             $type[, \%attributes])

This returns a statement handle for fetching information about a table in a database.

...
my $dbinfo = $dbh->table_info( );
while( my($qualifier,$owner,$name,$type,$remarks) =
       $dbinfo->fetchrow_array( )) {
   foreach ($qualifier,$owner,$name,$type,$remarks) {
      $_ = '' unless defined $_;
   }
   print "Info:  $qualifier $owner $name $type $remarks \n";
}