orcal列修改

增加列：alter table student add(stuPhone varchar(18));

删除列：alter table student drop column stuphone;

修改一列：alter table student modify(stuname varchar(12));//修改stuname列为12 字符修改表：

alter table student set unused column stuxxx;//把stuxxx设置为无用状态。

alter table student drop unused columns ;//此列已删除增加约束：

alter table student add constraint pk_stuno primary key(stuno);删除约束：alter table student drop constraint pk_stuno;