in reply to DBI recipes
++ 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;Source: An Introduction to Database Systems (7th edition), C.J. DateSCHEMATA 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
In Section
Meditations