如果你表中字段不多,建议如下操作: 1.将字段插入到表中 ALTER TABLE <table_name> ADD <column_name(N+1)> <data_type>; 2.创建新表 CREATE TABLE <table_name1> AS SELECT <column_name1>,<column_nameN>,<column_name2>,...,<column_nameN> from <table_name>; 3.删除老表 DROP TABLE <table_name> 4.更改新表表名 ALTER TABLE <table_name1> RENAME TO <table_name>
如果要修改次序,需要重建表!
确实不爽 强烈建议oracle改进
1.将字段插入到表中
ALTER TABLE <table_name> ADD <column_name(N+1)> <data_type>;
2.创建新表
CREATE TABLE <table_name1> AS SELECT <column_name1>,<column_nameN>,<column_name2>,...,<column_nameN> from <table_name>;
3.删除老表
DROP TABLE <table_name>
4.更改新表表名
ALTER TABLE <table_name1> RENAME TO <table_name>