++ Very useful node, thanks gmax.

For the sake of portability it might also be useful to note that ANSI SQL-92 provides a standard for querying table schema information:

select TABLE_NAME from INFORMATION_SCHEMA.TABLES

And to give an idea of what else is available via INFORMATION_SCHEMA;
SCHEMATA DOMAINS VIEWS COLUMNS TABLE_PRIVILEGES COLUMN_PRIVILEGES USAGE_PRIVILEGES DOMAIN_CONSTRAINTS TABLE_CONSTRAINTS REFERENTIAL_CONSTRAINTS CHECK_CONSTRAINTS KEY_COLUMN_USAGE ASSERTIONS VIEW_TABLE_USAGE VIEW_COLUMN_USAGE CONSTRAINT_TABLE_USAGE CONSTRAINT_COLUMN_USAGE CONSTRAINT_DOMAIN_USAGE
Source: An Introduction to Database Systems (7th edition), C.J. Date

In reply to Re: DBI recipes by EdwardG
in thread DBI recipes by gmax

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":