Thanks, table_info is ok.

I did "my @tables = $dbh->tables();",
it's a simple way but it has like;
`C:\temp\test`.`MSysAccessObjects`

Answer was not good.
I wonder if we had more smart way...

> $sth = $dbh -> table_info(undef, undef, '%', 'TABLE');
> 
> while ($data = $sth -> fetchrow_hashref() )
> {
>       $table_name = $$data{'TABLE_NAME'};
> ...
> }

Regards,
Hirosi Taguti

Reply via email to