H2 ALTER TABLE ADD COLUMN BEFORE/AFTER

Question

According to H2 syntax documentation available here I should be able to execute a query like:

ALTER TABLE EMPLOYEE ADD COLUMN SECOND_NAME VARCHAR (124) AFTER FIRST_NAME;

However apparently only this query works:

ALTER TABLE EMPLOYEE ADD COLUMN SECOND_NAME VARCHAR (124);

Is it a mistake in the documentation or am I missing something? The BEFORE and AFTER parameters would be useful to me.

The order of the columns in a relational table is irrelevant. Just change them in your SELECT statements. — user1822, Commented Jun 12, 2013 at 10:20
I know it is irrelevant in practice but in the documentation they have put this possibility for a reason. In my case it is that we often print the schema to paper and want some order for readability reasons. — dendini, Commented Jun 12, 2013 at 11:17

Patrick · Accepted Answer · 2014-10-09 23:56:25Z

2

It works for me. The H2 change log says it was added in version 1.3.171. Here is the original bug

alter table credentials add column domain VARCHAR(255) after credentialType;

What didn't work for me was having multiple adds inside one alter.

answered Oct 9, 2014 at 23:56

Patrick

1213 bronze badges

Add a comment |

1 Answer 1