DB2删除表字段

alter table WX_BUSINESS_MANAGER drop column CREATETIME

评论

1 楼 u010214413 2014-09-25  

ALTER TABLE TBNAME ADD COLUMN COLUMNNAME COLUMNTYPE COLUMNDEFAULTVALUE VALUE;
EG:
ALTER TABLE CIBCMS. T_TOL_CUST_VALIDADDR ADD COLUMN NVIPCORE_CFM_CNT BIGINT DEFAULT 0;

给表添加说明：
COMMENT ON COLUMN CIBCMS.T_TOL_CUST_VALIDADDR.NVIPCORE_CFM_CNT IS '已确认非VIP核心客户数量'