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

重命名列

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);

posted on 2017-09-17 18:12  mol1995  阅读(131)  评论(0编辑  收藏  举报

导航