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.
Asked by dendini
(395 rep)
Jun 12, 2013, 10:01 AM
Last activity: Feb 7, 2019, 12:15 PM
Last activity: Feb 7, 2019, 12:15 PM