Hi, The "describe" command was added before H2 supported the built-in SQL statement "show". I think it is no longer necessary to support "describe" in the H2 Shell; I have removed it now.
However, what I don't like about the Shell tool is that result sets are not nicely formatted (too many spaces). This is fixed now (in the trunk). Regards, Thomas On Thu, Jun 23, 2011 at 5:25 AM, Mattlock <[email protected]> wrote: > I see this behavior when using the H2 Shell, if I describe a table > that exists in multiple schemas I see an aggregate list of their > columns. For example: > > CREATE TABLE bar(id BIGINT, data VARCHAR); > CREATE SCHEMA foo; > CREATE TABLE foo.bar(id BIGINT, data2 VARCHAR); > SET SCHEMA foo; > DESCRIBE bar; > > The describe will show four columns: ID, ID, DATA, and DATA2. > Not sure if this is a bug, but I sure didn't expect what I saw. > > -- > 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. > > -- 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.
