Search code examples
jdbcderbyjavadb

How to move columns in java DB Apache Derby?

I need to change specific column's position I tried Ted Hopp's solution in Move Column in MYSQL

ALTER TABLE EMPLOYEES MODIFY COLUMN fname VARCHAR(25) AFTER password

and i got this error: 

Error code -1, SQL state 42X01: Syntax error: Encountered "MODIFY" at line 1, column 22.

So any idea how to do it with Derby

Solution

  • Derby uses ADD COLUMN (docs):

    ALTER TABLE EMPLOYEES ADD COLUMN fname VARCHAR(25)

    There is no way to insert columns before or after a certain column; they are always appended.