Search code examples
derbyalter

Alter table add column AFTER in derby database

Is there a way in a derby database to add a column after another just like mysql does?

Solution

  • I don't believe so. Column ordering isn't really a standard SQL feature. Well-written db applications shouldn't care about column ordering. You can specify the order of the columns in your output by naming the columns in your SQL statement as in:

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

    select b, c, a from t;