Hi. I an attempt to migrate from MSSQL Server to H2 i need to be able to query the available tables in the current schema.
My use case is as follows: I have a JDBC connection where the command "set schema ABC" have been executed. I want to know if a particullar table is present in the current schema by doing a query and give the ResultSet to the original code The code will then call "rs.next()" to determine if a row was returned (the content of the row is not read, just the fact that its there) In MSSQL Server we use databases instead of schemas so this is done using the query: SELECT name FROM sysobjects WHERE name = 'table' My problem is that using INFORMATION_SCHEMA means i need to know the name of the schema (which i don't at the time) Anyone? /Jacob -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/4egpcpUqGOAJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
