Low prio change request: Add support for ALTER TABLE .. RENAME COLUMN .. TO ..

[Lukas Eder]

Hello,

This would be nice to have, low prio.

Add support for alternative DDL syntaxes in order to improve database interoperability. E.g. support PostgreSQL's simpler column renaming syntax (http://www.postgresql.org/docs/9.5/static/sql-altertable.html)

ALTER TABLE distributors RENAME COLUMN address TO city;

In addition to H2's (http://www.h2database.com/html/grammar.html#alter_table_alter_column)

ALTER TABLE TEST ALTER COLUMN NAME RENAME TO TEXT;

The same applies for renaming constraints...

Cheers,

Lukas

[Lukas Eder]

Hmm, in fact, I've just noticed that according to the documentation, there is no way to rename a constraint... Would be good to have that option as well...

--
You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/8zt8k8hU1jA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[Noel Grandin]

Added support for these 2 things

[Lukas Eder]

Thank you very much!

2016-02-17 10:21 GMT+01:00 Noel Grandin <noelg...@gmail.com>:

Added support for these 2 things