一:简单粗暴
1,Oracle:
create table CFORM_COULUMN_2 as (select 字段A,字段B from CFORM_COULUMN);
2,Sqlserver
select 字段A,字段B.... into CFORM_COULUMN_2 from CFORM_COULUMN
二:通过SYS数据库更新字段顺序
1,查询表的ID
select object_id from all_objects where object_name = 'CFORM_COULUMN';
2,使用SYS账号切换到SYS数据库
3,查看表的字段详细情况
SELECT * FROM COL$ WHERE OBJ#='112043' ORDER BY COL#;
4,更新字段的顺序
UPDATE COL$ SET COL#=25 WHERE OBJ#='112043' AND NAME='DELETED';
UPDATE COL$ SET COL#=26 WHERE OBJ#='112043' AND NAME='COULUMN_DATA_SOURCE_TYPE';
5,重启数据库