alter table (表名) add (列名 数据类型);
|
alter table student add (score number(3)); |
alter table (表名) modify (列名 数据类型);
|
alter table student modify (score number(5,2)); |
alter table (表名) rename column (当前列名) to (新列名);
|
alter table student rename column score to fenshu; |
alter table (表名) drop column (列名);
|
alter table student drop column fenshu; |
|
rename student to stu; |
|
drop table stu; |
原文：https://www.cnblogs.com/qiaoxin11/p/12768270.html