谁会删除DB2的字段？

[softwarewl]

谁会删除DB2的字段？字段里已经写内容了

[njuzgj]

ORACLE里是ALTER TABLE T DROP COLUMN C

[yangxiao_jiang]

你在控制中心里就可以删除。

[yangxiao_jiang]

CONNECT TO TEST;
CALL SYSPROC.ALTOBJ ( 'APPLY_CONTINUE_ON_ERROR', 'CREATE TABLE TEST1 ( ID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 10) , "NAME" VARCHAR (50) NOT NULL , DEPT VARCHAR (50) NOT NULL ) IN USERSPACE1 ', -1, ? );
;
CONNECT RESET

[songfrh]

alter table ta drop column c5

[nicole_lixp]

新建备份表导出数据,DROP原表,重建,导入必要数据.

POWERDESIGN中可自动生成脚本