(1)删除该字段,然后重新添加
alter table table_name
drop column column_name
alter table table_name add(column_name type(legth))
(2)选择需要的字段重建该表
INSERT INTO NEW_TABLE(FIELD1,FIELD2,FIELD3)
SELECT FIELD1,FIELD2,FIELD3 FROM OLD_TABLE;
(1)删除该字段,然后重新添加
alter table table_name
drop column column_name
alter table table_name add(column_name type(legth))
(2)选择需要的字段重建该表
INSERT INTO NEW_TABLE(FIELD1,FIELD2,FIELD3)
SELECT FIELD1,FIELD2,FIELD3 FROM OLD_TABLE;