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
