On Sun, Nov 19, 2000 at 11:11:53PM +0000, Redvers Davies wrote:
> My question is this - is there a standard way of getting the
>list of tables and description of them?? eg:
>Does anyone know how can I do this in Foxpro or an ODBC database independent
>method?
man DBI:
@names = $dbh->tables;
Returns a list of table and view names. This list
should include all tables which can be used in a
select statement without further qualification. That
typically means all the tables and views owned by the
current user and all those accessible via public
synonyms/aliases (excluding non-metadata system tables
and views).
Note that table_info might not return records for all
tables. Applications can use any valid table
regardless of whether it's returned by tables. See
also the table_info entry elsewhere in this document.
Roger
--
clunum nunc vires mihi cunctae deficiunt
