列、约束重命名,原数据不丢失

重命名列

ALTER TABLE databack.apron_ts RENAME COLUMN airport_heliport2apron_ts to airport_heliport_uuid

重命名约束

ALTER TABLE AIRPORT_HELIPORT_TS RENAME CONSTRAINT "FK_EXVERSION-AIRPORRTTS1371" TO FK_EXVERSION_EFF;

更改列长度

alter table TERMPRO_RULE_ROUTE_QUALIFIER modify qualifiertype VARCHAR2(10);

原文地址:https://www.cnblogs.com/mol1995/p/7536517.html