Oh nice, I'm using 1.2.147.. I didn't realise there's a new stable version.
But don't you think the statement below should show columns from s1.t1 by default instead of public.t1? Because sometimes you might not know which schema is active because it's set elsewhere. SET SCHEMA S1; SHOW COLUMNS FROM T1; Regards, Anthony On May 10, 3:11 am, Thomas Mueller <[email protected]> wrote: > Hi, > > Which version of H2 do you use? This should work since version 1.3.154, see > alsohttp://www.h2database.com/html/changelog.html"MySQL compatibility: > SHOW COLUMN FOR schemaName.columnName." > > Regards, > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
