Alter table add column AFTER in derby database

Question

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

I wish they would add this too. I like the schema to look exactly the same whether it's brand new or migrated. — Hakanai, Jun 03 '12 at 22:45

score 2 · Accepted Answer · answered Mar 08 '12 at 19:39

2

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;

answered Mar 08 '12 at 19:39

Bryan Pendleton

16,128
3
32
56

2

Actually, it's just if someone opens the DB editor, the table does not look logic then. – Florian Müller Mar 09 '12 at 01:06

Alter table add column AFTER in derby database

1 Answers1