Hi, > I created a schema (let say SCHEMA1) then created a table in it. I > also created a table in PUBLIC schema. My question is why can't I see > the list of fields and their field type of the table created in the > SCHEMA1 versus table created in PUBLIC? How can I see the table > properties?
With 'see' do you mean in the H2 Console? Currently only the columns of the (default) schema PUBLIC are listed, otherwise all columns of the schema INFORMATION_SCHEMA would be listed as well, which would slow down the tool. However you can get the list of columns using the autocomplete feature. 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 -~----------~----~----~----~------~----~------~--~---
