Sample Header Ad - 728x90

H2 ALTER TABLE ADD COLUMN BEFORE/AFTER

4 votes
1 answer
21901 views
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