create table tmp as select ID,UserName,RealName,Sex,Tel,Addr from tabName;
drop table tabName;
rename tmp to tabName;
add Constraints,index,comments……
create table tmp as select ID,UserName,RealName,Sex,Tel,Addr from tabName;
drop table tabName;
rename tmp to tabName;
add Constraints,index,comments……