Change AFTER column column table in derby database

Question

Is there a way in the derby database to add a column after another in the same way as mysql?

Answer 1

I don’t believe that. The order column is not really a standard SQL function. Well-written db applications do not have to worry about column ordering. You can specify the order of the columns in your output by naming the columns in the SQL statement, as in:

create table t (a int, b int, c int);

select b, c, a from t;