Thanks Steve. That works. On Thursday, 14 February 2013 22:51:04 UTC-8, Steve McLeod wrote: > > 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.
