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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/89143a5f-6053-4638-914a-cb66d2b5af99n%40googlegroups.com.