Hello,
is there are any way to read names of all sequences from the database
metadata? Normally, one can use "sequence" table type to do this:
DatabaseMetaData meta = connection.getMetaData();
rs = meta.getTables(connection.getCatalog(), schemaName,
null, new String[]{ "SEQUENCE" });
This works for some other databases i have tried, but not for the H2.
First of all, H2 does not have such table type at all.
Secondly, for the getTables method the H2 queries the
INFORMATION_SCHEMA.TABLES table and all sequences metadata is stored
in the
INFORMATION_SCHEMA.SEQUENCES table.
So can anybody give me a hint how this information can be read? Is
there are any possibility to do this?
Cheers,
Slava
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
