Hi, In order to simplify the documentation, currently, not all variants of the grammar are documented, only those that are "recommended" (that's a fuzzy description, I know). That is, if people write new code, they should use the documented grammar, and not rely on the undocumented features. The undocumented features are for compatibility with other databases.
So, I wonder whether it is important to document that "column" is optional in those cases. Is it optional in the ANSI SQL standard? Regards, Thomas On Tuesday, May 6, 2014, Lukas Eder <[email protected]> wrote: > Hello, > > The manual is not entirely accurate about ALTER TABLE statements. Take > this statement for instance: > http://www.h2database.com/html/grammar.html#alter_table_alter_column > > The manual claims this syntax: > - ALTER TABLE tableName ALTER COLUMN columnName > > When in fact it should be this syntax: > - ALTER TABLE tableName ALTER [ COLUMN ] columnName > > I.e. the COLUMN keyword is optional. This is also true for DROP [ COLUMN > ]. The ADD [ COLUMN ] statement, however, is correct. > > Cheers > Lukas > > -- > 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]<javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to > [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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. For more options, visit https://groups.google.com/d/optout.
