Hi Noel, In fact H2 only seems to differentiate tables and views (TABLE and VIEW) but nothing on system tables (SYSTEM TABLE, GLOBAL TEMPORARY, LOCAL TEMPORARY, ALIAS, SYNONYM)
I haven't tried again recently, but in 2.2.219 it doesn't work... Le mardi 2 mai 2023 à 11:00:37 UTC+2, Noel Grandin a écrit : > > Assuming you are using the normal API, it's in the TABLE_TYPE column: > > > https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getTables-java.lang.String-java.lang.String-java.lang.String-java.lang.String:A- > > -- 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/89143a5f-6053-4638-914a-cb66d2b5af99n%40googlegroups.com.
