As follows: create cached temp table if not exists foobar ;
select count(*) from information_schema.tables where table_schema = 'PUBLIC' and table_type = 'TABLE' and storage_type = 'GLOBAL TEMPORARY' and table_name = 'FOOBAR'; If the select query returns 1, then the temporary table called FOOBAR exists. On Friday, 15 February 2013 12:39:33 UTC+11, Vineela Gampa wrote: > > Hi > > I have a table which i create using the statement "create cached temp > table if not exists" > > I want to check if this temp table exists. How can i do so ? > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
