sql - 重命名 DB2 中的列

Question

我正在尝试重命名一个表中已存在数据的列。但下面是它抛出的错误。请指教。

我试过的语法

ALTER TABLE TPR.PRODUCT_FEATURE RENAME COLUMN PRODUCT_ID TO SERVICE_ID

错误:

[Error] Script lines: 23-23 ------------------------ DROP, ALTER, TRANSFER OWNERSHIP, REVOKE, or CREATE OR REPLACE on object type "COLUMN" cannot be processed because there is an object "PRODUCT_FEATURE_X01", of type "PRIMARY KEY", which depends on it.. SQLCODE=-478, SQLSTATE=42893, DRIVER=3.67.28

在我看来，我需要放弃并重新创建是唯一的选择。请指教。

Answer 1

删除约束:

ALTER TABLE TPR.PRODUCT_FEATURE 
    DROP CONSTRAINT PRODUCT_FEATURE_X01

然后改变你的表:

ALTER TABLE TPR.PRODUCT_FEATURE RENAME COLUMN PRODUCT_ID TO SERVICE_ID

然后添加新的约束:

ALTER TABLE TPR.PRODUCT_FEATURE
      ADD CONSTRAINT PRODUCT_FEATURE_X01
      PRIMARY KEY (insert,columns,here)