use strict;
use warnings;
use DBI;

my $dbh = DBI->connect(...);
my @tables = $dbh->tables(undef, undef, undef, 'TABLE');

print "$_\n" for @tables;