ORACLE
重命名表字段时报错!SQL语句如下:
ALTER TABLE BDGH_INST.BZ_GHSJYQ RENAME JZGDXX TO JZGDXX_TEMP;
报错原因是缺少COLUMN
关键字!重命名表字段正确写法应该是如下所示
/* 将 JZGDXX 重命名为 JZGDXX_TEMP */
ALTER TABLE BDGH_INST.BZ_GHSJYQ RENAME COLUMN JZGDXX TO JZGDXX_TEMP;
ORACLE
重命名表字段时报错!SQL语句如下:
ALTER TABLE BDGH_INST.BZ_GHSJYQ RENAME JZGDXX TO JZGDXX_TEMP;
报错原因是缺少COLUMN
关键字!重命名表字段正确写法应该是如下所示
/* 将 JZGDXX 重命名为 JZGDXX_TEMP */
ALTER TABLE BDGH_INST.BZ_GHSJYQ RENAME COLUMN JZGDXX TO JZGDXX_TEMP;