CODEWITHSUNDEEP
derbyalter
Florian Müller
Florian Müller

Reputation: 7785

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?

Upvotes: 5

Views: 1745

Answers (1)

Bryan Pendleton
Bryan Pendleton

Reputation: 16359

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;

Upvotes: 2

Related Questions