Hi Gary, Read again. http://www.h2database.com/html/grammar.html?highlight=show&search=show#show
for your schema main.devices, use show columns from devices from main Regards. On Mar 25, 7:17 pm, Gary <[email protected]> wrote: > Hi folks > > Using 1.3.153, created an embedded file-backed database. > > Create a table 'devices' in the default (PUBLIC) schema. Ran "SHOW > COLUMNS FROM devices" all works as expected. > > Decided to put table in a new schema (called MAIN). Now when I open a > connection on that schema I can select from devices but the above SHOW > COLUMNS call now returns zero rows. > > Noticed that command "SHOW COLUMNS FROM tablethatdoesnotexist" will > also return zero rows. > > Also "SHOW COLUMNS FROM MAIN.DEVICES" returns syntax error. > > I had to work around this by doing a equivalent "SELECT column_name > FROM INFORMATION_SCHEMA.COLUMNS". > > Cheers > > Gary -- 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.
