Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If you are using the embedded HSQLDB engine these will give you that information. Table names are in column TABLE_NAME in this query:

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TABLE_TYPE='TABLE';

Column names (and other column parameters) are obtained by this query:

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME NOT LIKE 'SYSTEM_%';