db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: How to insert new column in front of exsiting column?
Date Wed, 13 May 2009 18:11:04 GMT
> I saw the "alter table" only insert the column to the end of the table,

Yes, but you can retrieve your columns in any order. For example:

create table t (a int, b int, c int, d int);
alter table t add column e int;

select a,b,c,d,e from t; -- this is fine
select e,a,d,c,b from t; -- this is fine, too

thanks,

bryan



Mime
View raw message