createtable liu(a varchar2(20),b number(2)) altertable liu rename to jin rename jin to cai altertable cai add c varchar2(30) altertable cai add (d varchar2(30),e number(4)) altertable cai rename column e to f altertable cai modify d varchar(40) altertable cai modify f varchar(40) altertable cai dropcolumn f