I found a post at http://h2-database.66688.n3.nabble.com/Best-practice-Test-for-existence-of-table-etc-td4024451.html
which said that the correct method was: select count(*) from information_schema.tables where table_name = ? However, I cannot get any results in doing such a search if I have a where clause in the statement. I have been testing this from the H2 web console and driving my self nuts If I use "SELECT * FROM INFORMATION_SCHEMA.TABLES" I get all the tables If I use any kind of where clause on any of the columns I get zero rows. For example where table_name='name' where table_name = null where table_name ! =null where table_name like 'name' where table_type != null Is there any way to modify the query to get this to work? -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
