4

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.

dendini
  • 395
  • 2
  • 6
  • 13

1 Answers1

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.

Patrick
  • 121
  • 3