You can use something like that:
SELECT
TABLE_CATALOG TABLE_CAT,
TABLE_SCHEMA TABLE_SCHEM,
TABLE_NAME,
CASE WHEN TABLE_SCHEMA = 'INFORMATION_SCHEMA' THEN 'SYSTEM TABLE' WHEN
TABLE_TYPE = 'BASE TABLE' THEN 'TABLE' ELSE TABLE_TYPE END,
REMARKS,
CAST(NULL AS VARCHAR) TYPE_CAT,
CAST(NULL AS VARCHAR) TYPE_SCHEM,
CAST(NULL AS VARCHAR) TYPE_NAME,
CAST(NULL AS VARCHAR) SELF_REFERENCING_COL_NAME,
CAST(NULL AS VARCHAR) REF_GENERATION
FROM INFORMATION_SCHEMA.TABLES;
You need to add WHERE clause when DatabaseMetaData.getTables() was called
with filtration parameters.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/7addbc0a-3f13-498b-a3cb-a99c3195f8b0n%40googlegroups.com.
